How to get Max value for group of column

[Anonymous]

HI Team,

I am trying to get maximum value of % column but its always giving me 1. I am using below measure but its giving 1 to non zero values.

MaxHrs = MAXX(ResourceProjection,ResourceProjection[%])

ResourceProjection is table name and [%] is value whose max is required. In below exp,for month of June,max % should be 7.88 but MAXX comand giving me 1. For Aug,Max value should be 13.62 but still getting 1. Grouping should be based on Category and Month.   Can anybody please help me in this situation.

Thanks on advance for the solution.

[mdaatifraza5556 · Accepted solution]

Hi @Anonymous 

Above are the steps I followed to achieve it.

Below is the snapshot of each steps

If this answers your questions, kindly accept it as a solution.
If this is helpful, then pelase give kudos.

[v-csrikanth · Accepted solution]

Hi @Anonymous ,
Thank you for reaching out to Microsoft Fabric Community Forum.
Please find below DAX code as per your requirement.

MaxHrs = 
MAXX(SUMMARIZE(ResourceProjection,ResourceProjection[category ],ResourceProjection[Month],"HRS",
SUM(ResourceProjection[%])),
[HRS]
)

Please find attached snap.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

[Anonymous]

Hi @v-csrikanth , I have tried with this code and its working now..Thanks for your help!!

[mdaatifraza5556]

Hi @Anonymous 

Try the below steps to get your result 

step1 
       Create a summarized table using below DAX

SUMMARIZETBL =

SUMMARIZE(

    ResourceProjection,

    ResourceProjection[Category],

    ResourceProjection[Month],

    "@total%", SUM(ResourceProjection[%]))
----------------------------------------------------------------------

Steps2

       Create a measure using below DAX 

output =

    CALCULATE(

        MAX(SUMMARIZETBL[@total%]),

        ALLEXCEPT(SUMMARIZETBL, SUMMARIZETBL[Month]

        ))

If this answers your questions, kindly accept it as a solution.
If this is helpful, then pelase give kudos.

[mdaatifraza5556 · Accepted solution]

Hi @Anonymous 

Above are the steps I followed to achieve it.

Below is the snapshot of each steps

If this answers your questions, kindly accept it as a solution.
If this is helpful, then pelase give kudos.

[Anonymous]

HI @mdaatifraza5556   I have tried with your code as well and its working fine.  However, vsrikant's code is minimum so its useful while loading process..Thanks for your help!!