Forum Discussion

Topjacket's avatar
Topjacket
Icon for Helper I rankHelper I
2 years ago

Distinct Count all except all page filters

Hi

 

Is it possible to distinct count a field, ignoring selected filters but including the "All Pages" filters? I could obviously replicate the All pages filters but I would prefer not to as if they ever change, I will need to remember to change the measures.

 

The basic dax I am using at the moment is below but as I have found out this also ignores the "All Pages" filters

 

CALCULATE(DISTINCTCOUNT(MASTER_DATA[Company]),All(MASTER_DATA))
 
Any tips would be great.
 
Thanks

1 Reply

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    2 years ago

    hi Topjacket ,

     

    what do you mean by "ignoring selected filters but including the "All Pages" filters? "?