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 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

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.

4 Replies

  • pankajnamekar25's avatar
    pankajnamekar25
    Super User
    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.

  • 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.

  • 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.