Display a column in a matrix based on a condition

[AmiraBedh]

I have a following dimension Geography linked to FactSales in an SSAS Tabular model, I want to display a column in a matrix based on conditions :

Example, the matrix display in Power BI :

Georaphic Position      Sales Amount

Americas                       500K

   Undefined                  500K

          T1                        150K

          T2                        350K

 The Sales Amount is a measure, in the matrix I want to skip any level where 'Undefined' is mentioned and show only its children :

Georaphic Position      Sales Amount

Americas                       500K

   T1                               150K

      T2                            350K

the dimension Geography is not conceived as a Parent - Child, should I start thinking about implementing it in that way ?

[Anonymous · Accepted solution]

Hi @AmiraBedh ,

Please refer to my pbix file to see if it helps you.

Create a measure.

Measure =
IF (
    MAX ( 'Table'[Georaphic Position] ) = "Undefined",
    BLANK (),
    [Sales Amount_measure]
)

If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.

 Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.