Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 = CALCULAT...
  • VahidDM's avatar
    VahidDM
    4 years ago

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

     

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

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