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
Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Naveen29 ,

 

Have you tried below code:-

Measure = [YTD]&" "&[PYYTD]

Note:- [YTD] and [PYYTD] represnt your measure for particular calculation.

 

Thanks,

Samarth

 

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    4 years ago

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

    • Samarth_18's avatar
      Samarth_18
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Syndicate_Admin For that you dont need to create a seperate measure, you can directly drag YTD measure.

    • 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.