Forum Discussion
Solved
Measure with IF statement and filter context
Dear all, I am curious, wheter this is possible. Within calculated measure I am trying to calculate alternative results depending on the dimension. Let me explain on an demo/example: I have got Ta...
Try using the below measure:
Measure = SWITCH(TRUE(), MAX(Table1[Item]) = "EBIT", SUM(Table1[Amount]), MAX(Table1[Item])= "EBIT%",CALCULATE(SUM(Table1[Amount]),Table1[Item] = "EBIT")/CALCULATE(SUM(Table1[Amount]),Table1[Item]="Revenue"), CALCULATE(SUM(Table1[Amount]),Table1[Item]="Revenue"))HYG. I calculated EBIT% as a variable and used Format function to change the format :)
Measure = var EB = CALCULATE(SUM(Table1[Amount]),Table1[Item] = "EBIT")/CALCULATE(SUM(Table1[Amount]),Table1[Item]="Revenue") return SWITCH(TRUE(), MAX(Table1[Item]) = "EBIT", SUM(Table1[Amount]), MAX(Table1[Item])= "EBIT%",FORMAT(EB,"Percent"), CALCULATE(SUM(Table1[Amount]),Table1[Item]="Revenue"))
yes. thanks.
One related question came to my mind: now I have results in one table:
Item Measure
EBIT 4
Revenue 80
EBIT % 0.4
Is there a trick, to get %-sign for EBIT %?
Means:
Item Measure
EBIT 4
Revenue 80
EBIT % 0.4%
Thx.
HYG. I calculated EBIT% as a variable and used Format function to change the format :)
Measure =
var EB = CALCULATE(SUM(Table1[Amount]),Table1[Item] = "EBIT")/CALCULATE(SUM(Table1[Amount]),Table1[Item]="Revenue")
return
SWITCH(TRUE(),
MAX(Table1[Item]) = "EBIT", SUM(Table1[Amount]),
MAX(Table1[Item])= "EBIT%",FORMAT(EB,"Percent"),
CALCULATE(SUM(Table1[Amount]),Table1[Item]="Revenue"))Works lika a charm.
Many thanks for your support.
R.