Forum Discussion
Solved
Using Treatas without Filtering the Dataset
Hi Everyone, Hope you are doing good. I have 2 sample datasets as below: I have created a measure named Amt_Total_Treatas = CALCULATE(SUM(Amt[Amt]), TREATAS(VALUES('Group'[Cu...
I think the below should work. It will give the value for the current group if the group is in scope, otherwise it will give the total
Amt Total Treatas = VAR AllAmtNames = DISTINCT ( Amt[Cust] ) VAR AllGroupNames = DISTINCT ( ALL ( Group[Cust] ) ) VAR MissingAmtNames = EXCEPT ( AllAmtNames, AllGroupNames ) VAR Result = IF ( ISINSCOPE ( Group[Cust] ), CALCULATE ( SUM ( Amt[Amount] ), TREATAS ( VALUES ( Group[Cust] ), Amt[Cust] ) ), CALCULATE ( SUM ( Amt[Amount] ), TREATAS ( UNION ( VALUES ( Group[Cust] ), MissingAmtNames ), Amt[Cust] ) ) ) RETURN Result
