Forum Discussion

Blazej_13's avatar
Blazej_13
New Member
1 year ago
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...
Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    1 year ago

    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.

v-kathullac's avatar
v-kathullac
Community Support
1 year ago

Thanks pankajnamekar25  for Addressing the issue.

 

Hi Blazej_13 ,
we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,

Chaithanya.