Forum Discussion

jyaul786's avatar
jyaul786
Icon for Helper II rankHelper 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
DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi,

 

try this measure to replace your value field in the matrix:

 

Value Measure= SWITCH(TRUE(),and(ISINSCOPE('Table'[Level3]),ISBLANK(VALUES('Table'[Level3]))),BLANK(),and(ISINSCOPE('Table'[Level4]),ISBLANK(VALUES('Table'[Level4]))),BLANK(),SUM('Table'[value]))
 
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
  • jyaul786's avatar
    jyaul786
    Icon for Helper II rankHelper 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
      Icon for Resident Rockstar rankResident 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
        Icon for Super User rankSuper User
        2 years ago

        your method will only work if you create a hierarchy