Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Conditional display for total in matrix

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 th...

6 years ago

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 )
    )

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

Icon for Community Champion rank

Community Champion

6 years ago

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-Roll/m-p/411443#M150

Related content