Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Maximum for a measure

Hello,   Here is my problem.    I have companies and I have 3 categories, C, D and H. (There are relationship between tables)   I measured deviations, and I made a matrix which shows me per com...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    The solution to my problem is :

     

    Max Value deviation = MAXX(DISTINCT(Categories),[Deviation])
VasTg's avatar
VasTg
Icon for Memorable Member rankMemorable Member
6 years ago

@Calice

Do you want to see the value 20 in all categories or only at the enterprise level?

Have you tried to click the down arrow on the deviation measure and select Maximum?

image.pngThe image is just an example of where to find the down arrow

If it helps, mark it as a solution

Congratulations are also good