Forum Discussion

vkisa's avatar
vkisa
Helper II
2 years ago
Solved

Creating Custom Subrows as Percentage Changes

Hi, I need to add a subrow that calculates of percentage change for between specific 2 different time periods as below.     Type Sum of Revenue Yesterday 229,925.28 SDLM 196,666.63 ...
"DAX help"
Hierarchy of matrix
  • lbendlin's avatar
    lbendlin
    2 years ago

    Here is the general approach

     

    note that you cannot mix data formats unless you convert everything to to text.

     

lbendlin's avatar
lbendlin
Super User
2 years ago

yes, that's what you need to do. Replace the "1"  with the appropriate measure.

vkisa's avatar
vkisa
Helper II
2 years ago

I guess, we can not hide the blank Type_General row, while the subrows appear,right? 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    correct

    • vkisa's avatar
      vkisa
      Helper II
      2 years ago

      Thank you lbendlin ,

      Do you have any idea how can I manage it? 

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        make the measure return BLANK() for that scenario