topic Combine Measure Selected Value Format with Calculate in DAX Commands and Tips

Combine Measure Selected Value Format with Calculate

Anonymous — Thu, 04 Nov 2021 06:49:49 GMT

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.

Re: Combine Measure Selected Value Format with Calculate

VahidDM — Sat, 06 Nov 2021 22:34:55 GMT

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