DAX Calculation

[Blazej_13]

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 for particular item - how the formula should look like to get max in each row so 523.9.
Also when I will remove filter how the formula should look to give max for each material in month provided by the slicer.

Thanks

[v-kathullac]

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.

[v-kathullac]

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.

[v-kathullac]

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.

[pankajnamekar25 · Accepted solution]

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.