Forum Discussion

jyaul786's avatar
jyaul786
Helper II
2 years ago

Hide/remove matrix rows

Dear Friend, i have one table with Level1,Level2,Level3,Level4 and value, i want to display in Matrix with hierarchy. Data: Level1 Level2 Level3 Level4 value Asset current bank bank1 ...
Need Help
jyaul786's avatar
jyaul786
Helper II
2 years ago

i tried your measure but i have still empty rows as:

measure=

SWITCH(
   TRUE(),
   and(ISINSCOPE('Table test'[Level3]),ISBLANK(VALUES('Table test'[Level3]))),BLANK(),
   and(ISINSCOPE('Table test'[Level4]),ISBLANK(VALUES('Table test'[Level4]))),BLANK(),SUM('Table test'[value])
   )

 

 

DOLEARY85's avatar
DOLEARY85
Resident Rockstar
2 years ago

Strange it works with the test data you provided, without being able to view your file i'm not sure what other solution could work.

 

I've attached my PBIX file for you to review, hopefully it will provide some additional help:

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    your method will only work if you create a hierarchy

    • DOLEARY85's avatar
      DOLEARY85
      Resident Rockstar
      2 years ago

      If you replace the hierarchy in rows of the matrix with the individual lvl 1 - 4 fields it still works in the sample PBIX file I uploaded.

      • Ahmedx's avatar
        Ahmedx
        Super User
        2 years ago

        it works in your file, but not in others
        try my file.
        I'm wondering why your file works and in others the measure doesn't work

  • jyaul786's avatar
    jyaul786
    Helper II
    2 years ago

    Hello DOLEARY85 

    Its working fine but when i export date from matrix, i got only Assets. could you please help ?

     

     

    Exported data:

     

    • jyaul786's avatar
      jyaul786
      Helper II
      2 years ago

      DOLEARY85 

      Kindly Reminder please, its really very important.