Forum Discussion

SQL_McOLAP's avatar
SQL_McOLAP
Frequent Visitor
8 years ago
Solved

Dynamic DAX Measure Not Showing In Charts

Hi -   Our end users really like an ad-hoc screen we set up where they can choose a bunch of measures they want to analyze.  Without formatting, those measures could get hard to read, especially wh...
Need Help
Tips and Tricks
  • SQL_McOLAP's avatar
    SQL_McOLAP
    8 years ago

    So I think the answer to my question is to have TWO measures.  One with the SWITCH that calcs the ad hoc measure the user selected, and another measure that does the same but has the FORMAT function around all of them.  The first one would be used for charting, and the second one, with the FORMAT function would be for tables/matrices and Tooltips, for user-readability.

     

    If someone knows of a way to do this WITHOUT creating a second measure, let me know, becuase we have over 175 measures in our cube, and the DAX to do all this is pretty lengthy.

     

    Thanks!

     

    -Phil (SQL McOLAP)

SQL_McOLAP's avatar
SQL_McOLAP
Frequent Visitor
8 years ago

So I think the answer to my question is to have TWO measures.  One with the SWITCH that calcs the ad hoc measure the user selected, and another measure that does the same but has the FORMAT function around all of them.  The first one would be used for charting, and the second one, with the FORMAT function would be for tables/matrices and Tooltips, for user-readability.

 

If someone knows of a way to do this WITHOUT creating a second measure, let me know, becuase we have over 175 measures in our cube, and the DAX to do all this is pretty lengthy.

 

Thanks!

 

-Phil (SQL McOLAP)

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi SQL_McOLAP,

 

Thanks for your sharing resolution.

 

Regards,

Yuliana Gu