Forum Discussion
Combine Measure Selected Value Format with Calculate
Hi All,
I have a matrix table with the list of KPI in the rows with different data format (Currency & Percentage).
How can I combine the DAX Measure if I already have these measure:
Act = CALCULATE(sum('KPI Performance'[Val]),filter('KPI Performance','KPI Performance'[Type]="Actual"))
I want to combine with IF(SELECTEDVALUE('KPI Performance'[Attribute])="%GROWTH", FORMAT(CALCULATE(SUM('KPI Performance'[Val])),"Percent"),FORMAT(CALCULATE(SUM('KPI Performance'[Val])),"Currency")
Thank you.
Hi Anonymous
Can you add more details about your request? do you want to change Act format?if yes, try this:
Act =
Var _A = CALCULATE(sum('KPI Performance'[Val]),filter('KPI Performance','KPI Performance'[Type]="Actual"))
return
IF(SELECTEDVALUE('KPI Performance'[Attribute])="%GROWTH", FORMAT(_A,"Percent"),FORMAT(_A,"Currency"))If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
1 Reply
- VahidDM
Super User
Hi Anonymous
Can you add more details about your request? do you want to change Act format?if yes, try this:
Act =
Var _A = CALCULATE(sum('KPI Performance'[Val]),filter('KPI Performance','KPI Performance'[Type]="Actual"))
return
IF(SELECTEDVALUE('KPI Performance'[Attribute])="%GROWTH", FORMAT(_A,"Percent"),FORMAT(_A,"Currency"))If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!