Forum Discussion

Naveen29's avatar
Naveen29
Helper 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
Community 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
    Administrator
    4 years ago

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

    • Samarth_18's avatar
      Samarth_18
      Community 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
      Community 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
        Helper 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.