Understand is in scope in my case

[nicolast29]

Hi

I don't arrive to find a solution, for a case that for me is standard, but i have a lack of dax in this case

I use a matrix with different level of granularity,  I only want the sum at the last levet (genre)

I precise that this example is not my real world

For example is i am on the first level i want blank

if i am at the second level, blank

if only the first level il selected i want a blank value

I try a lot of is in scope and is filtered ... but i miss the clue

here my file

test countrow.pbix

thanks so much for the help

[Anonymous]

Hi @nicolast29 ,

Do you want to display a total value when the user expands the third level? If so , you could consider enabling Row subtotals. Then, by selecting Row level, you can set the other two levels individually and adjust their subtotal visibility to 'off' as needed.

Best Regards,

Bof

[nicolast29]

hi, thanks for the answer

But it is not ok because itshow a total at melbourne when melbourne is not drilled

[lbendlin]

Cannot reproduce

[nicolast29]

Hi

You file work, but cannot reproduce the solution on mine ....

For the other may be another way because I finally found a solution this night and found why my measure doesn't work, 

I use to much of blank, like this it works:

Fréquence_repas_suppérieur_à_un_v3 =

     iF(

        DIVIDE(COUNTROWS('f_Global & détails'),DISTINCTCOUNT('f_Global & détails'[Nom & Prénom Invité]),1)

            > 1,

            SWITCH(TRUE,

                [0_isinscopt_n3],

                IF(COUNTROWS('f_Global & détails') > 1,

                     COUNTROWS('f_Global & détails'),

                            BLANK()),

            [0_isinscopt_n2],"",

            [0_isinscopt_n1],""

            )

     )