Forum Discussion
Difference between measure and variable
Hi, I am a bit confuse about the use of a variable and the use of a measure in a measure: Here i want to have the difference between max and min per category (a and b) and afterwards sum the di...
Works, very nice measure tnx!!
HI Anonymous,
You can use following measure if it works:
Measure =
SUMX (
SUMMARIZE (
Table,
[Type],
"Max", MAX ( Table[Value] ),
"Min", MIN ( Table[Value] )
),
[Max] - [Min]
)
Regards,
Xiaoxin Sheng
Works, very nice measure tnx!!