Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Max results in infinity

Hi I am trying to create the max value for my dataset, my DAX calc results in "Infinity".  I have created a measure to determine the Density of my dataset for each "Entry":  Density = CALCULATE(...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

    You can try the following measure

    MaxDensity =
VAR a =
    SUMMARIZE ( ALLSELECTED ( Sheet1 ), [Entry], "Density", [Density] )
RETURN
    MAXX ( a, [Density] )

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Kishore_KVN's avatar
Kishore_KVN
Icon for Solution Sage rankSolution Sage
2 years ago

Hello Anonymous ,

Is there any possibility that you can share the pbix file to look at the error. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Kishore, thanks, I have originally attempted this - I have the PBIX file ready but I cannot see how to upload it to this post, any ideas?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

    You can try the following measure

    MaxDensity =
VAR a =
    SUMMARIZE ( ALLSELECTED ( Sheet1 ), [Entry], "Density", [Density] )
RETURN
    MAXX ( a, [Density] )

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.