Combine Measure Selected Value Format with Calculate

Meishka 1 Reputation point
2021-11-04T04:30:40.63+00:00

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.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,988 questions
0 comments No comments
{count} votes