Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Hide last level values from matrix table

    Posted Dec 28, 2022 10:26 AM
    Hi everyone,

    I have a matrix table that l need to hide the value of last level.
    Someone can help me with this?

    This is how my data looks like:

    Continent Country State Total
    North America USA NewYork 25
    North America USA Texas 25
    North America USA Florida 25
    North America USA Virginia 25
    North America Canada British Columbia 15
    Asia India Andhra Pradesh 20
    Asia India Tamil Nadu 20
    Asia India Karnataka 20
    South America Brasil São Paulo 30


    My expecteds outputs
    : I want to show the output in Matrix table 3 levels (Continent, Country and State) sales. But I only want to see total in Continent and Country Level but if expand to State it should be blank as mentioned below.

    -At Country Level:
    Continent Total
    North America 115
    Asia 60
    South America 30

    -After expand to country level:
    Country Total
    North America 115
    USA 100
    Canada 15
    Asia 60
    India 60
    South America 30
    Brasil 30

    -After expand to state level:
    Continent Total
    North America 115
    USA 100
    NewYork  
    Texas  
    Florida  
    Virginia  
    Canada 15
    British Columbia  
    Asia 60
    India 60
    Andhra Pradesh
    Tamil Nadu
    Karnataka
    South America 30
    Brasil 30
    São Paulo

    Thanks,
    Lucas

    ------------------------------
    Lucas A
    ------------------------------


  • 2.  RE: Hide last level values from matrix table

    Posted Dec 29, 2022 09:23 PM
    Veja se ajuda

    Total = 
    IF ( ISINSCOPE ( Tabela[State] ), "", SUM ( Tabela[Valor] ) )​



    ------------------------------
    Vilmar Santos
    ------------------------------