Forum Discussion

Naveen29's avatar
Naveen29
Icon for Helper II rankHelper II
4 years ago

DAX help

I would like to display the data in the matrix table as follows. The measure values should display the YTD vs PYTD for country level, and loc wise it should be only YTD value.   How to achive this?...
Need Help
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

this is fine. How to show only YTD in the values

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Naveen29 

If you want to display the YTD vs PYTD for country level and YTD value for loc wise, you can create measure as blow to replace the value:

 

Measure1 =
IF ( ISFILTERED ( Table1[loc] ), [YTD], [YTD] & "VS" & [PYTD] )

 

 

Best Regards,
Community Support Team _ Eason

  • Naveen29's avatar
    Naveen29
    Icon for Helper II rankHelper II
    4 years ago

    v-easonf-msft I tried this DAX even though it is giving or considering only one measure in the matrix table column.

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi, Naveen29 

      Can you share your pbix file (without sensitive data) and related formulas you used?

       

      Best Regards,
      Community Support Team _ Eason