Forum Discussion

Anonymous's avatar
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...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    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 )
    )

    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.