Combine Measure Selected Value Format with Calculate

[Anonymous]

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.

[VahidDM · Accepted solution]

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!!