Welcome in Dinesh Patel Blog

How to apply Except filter in DAX? Total YTD = TOTALYTD([Total Value], 'Date'[Date],filter('Fact',not(CONTAINS('Mapping Table','Mapping Table'[Attribute1 SK],'Fact'[Attribute1 SK], 'Mapping Table'[Attribute2 SK], 'Fact'[Attribute2 SK])))) How to apply HasoneFilter in Total YTD? Total YTD = IF(ISFILTERED('Product'[Category]), TOTALYTD([Total Value], 'Date'[Date], filter('Fact',not(CONTAINS('Mapping Table','Mapping Table'[Attribute1 SK],'Fact'[Attribute1 SK], 'Mapping Table'[Attribute2 SK], 'Fact'[Attribute2 SK])))),TOTALYTD([Total Value], 'Date'[Date])) How to apply IsFiltered with conditional exception? Base_Measure = IF(ISFILTERED('Product'[Super Category]) && NOT(ISFILTERED('Product'[Super Category])) , CALCULATE(SUM('Fact'[Measure]), 'Fact'[Flag] <> 1), SUM('Fact'[Measure])) Final1_Measur...