Conditional display for total in matrix

[Anonymous]

I have a matrix with the following fields:

I add a total for level2

How can I hide level2 when it's blank and I need to keep the total for level1?

For example the following picture, For the line "Moto" I need to hide the line when  level 2 is null  I need to keep to display the total?

Expected results:

Dim5RapportDim6RapportAN

Auto	Total	4
	Click & go	2
	Refeerence	2
Moto	Total	2
Sante	Total	2

I put an example here
https://drive.google.com/file/d/10s7o4Ojl4JAq7qIjIAY29hB99tRGLyIZ/view?usp=drivesdk

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Create a measure as a logical condition for [AN].

Measure 2 =
VAR test1 =
    IF ( ISINSCOPE ( Dim_Produit[Dim6Rapport] ), TRUE () )
RETURN
    IF (
        ISINSCOPE ( Dim_Produit[Dim5Rapport] )
            && MAX ( Dim_Produit[Dim6Rapport] ) <> "null",
        TRUE (),
        NOT ( test1 )
    )

Sample .pbix

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

[amitchandak]

@Anonymous , refer if this can help

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

[Greg_Deckler]

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also, MM3TR&R: https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...