Forum Discussion
DAX HELP - How to implement dynamic totals when conditionally aggregating
Hi there, Was wondering if someone could help.. I have the following DAX Expression: _UsageLastXDays =
VAR MinUsageDate =
CALCULATE ( MIN ( Dates[DateISO] ), GameUsage )
RETURN
IF (
...
mahoneypat
Microsoft Employee
Microsoft EmployeeIf it is just those two scenarios (A or A+B) then you can use ISINSCOPE on the B column to determine which expression to return. Use your one above for the A only scenario, and the SUMMARIZE equivalent with A and B for that scenario.
Regards,
Pat