Forum Discussion
Measure with a variable
Hi, I am trying to upgrade a company report such that it is future proof. I am currently facing a seemingly simple problem which has been bugging me for the past 2 days. I can't share the data bu...
Hi Anonymous
it looks like you need MINX() function like
Measure = CALCULATE( MINX('Table', CALCULATE(MAX('Table'[Value]),ALLEXCEPT('Table','Table'[Class]))), ALL('Table') )- Here's the full and correct solution:
https://1drv.ms/u/s!ApyQEauTSLtOgYM665_GXHuUZylVyw?e=IQUTF8
Best
D
Hi Anonymous
it looks like you need MINX() function like
Measure =
CALCULATE(
MINX('Table',
CALCULATE(MAX('Table'[Value]),ALLEXCEPT('Table','Table'[Class]))),
ALL('Table')
)