topic Re: Understand is in scope in my case in DAX Commands and Tips

Understand is in scope in my case

nicolast29 — Wed, 16 Oct 2024 16:50:03 GMT

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

Re: Understand is in scope in my case

lbendlin — Wed, 16 Oct 2024 20:36:45 GMT

Cannot reproduce

Re: Understand is in scope in my case

Anonymous — Thu, 17 Oct 2024 08:37:17 GMT

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

Re: Understand is in scope in my case

nicolast29 — Thu, 17 Oct 2024 16:06:21 GMT

hi, thanks for the answer

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

Re: Understand is in scope in my case

nicolast29 — Thu, 17 Oct 2024 16:14:52 GMT

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],""

)