Forum Discussion
Solved
DAX Calculation
Hello, I am a newbie in Power BI and want to get maxx for specific material in filtered month: formula: MAXX (ALLSELECTED (DIM_Date'[DateID]),[Measure]) results: Table is filtered...
Hello Blazej_13
try this measure
Max Measure PerMaterial =
CALCULATE(
MAXX(
VALUES(DIM_Date[DateID]),
[Measure]
),
ALLEXCEPT(FactTable, FactTable[MaterialID])
)
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hello Blazej_13
try this measure
Max Measure PerMaterial =
CALCULATE(
MAXX(
VALUES(DIM_Date[DateID]),
[Measure]
),
ALLEXCEPT(FactTable, FactTable[MaterialID])
)
Thanks,
Pankaj Namekar | LinkedIn
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.