Distinctcount with Filters

[Anonymous]

Hello,

in this example

I'd like to distinctcount the Brand without the filter combination [Category] = NO and ([Day Segment] = Weekday and [Day Segment] = Weekend).

Here Brand A, E and G should not be counted because these contain the filters above.

So only B, C, F and H should be counted, result would be 4.

My Measure didn't work out

[v-diye-msft]

Hi @Anonymous 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!

[harshnathani]

Hi @Anonymous ,

Create a measure

DC =

var _filterTable = FILTER('Table','Table'[Category] <> "No" && 'Table'[Segment] IN {"Weekend","Working Day"})

RETURN

CALCULATE(DISTINCTCOUNT('Table'[Brand]),_filterTable)

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Thank you guys

what I'd like to have furthermore, is a chart also with "NO" on x-axis.

For example Brand H should be displayed and counted as NO in the chart. The chart is filtered by Weekend.

Is it possible to enhance the measure, so we can see the count of Brands, which are "No" and "Weekend" and not "NO" and "Working Day"?

[harshnathani]

Hi @Anonymous ,

Create a new measue.

NoandWeekend =

var _filterTable = FILTER('Table','Table'[Category] = "No" && 'Table'[Segment] IN {"Weekend"})

RETURN

CALCULATE(DISTINCTCOUNT('Table'[Brand]),_filterTable)

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[tex628]

The filter statement in the end looks incorrect! 

Change it to,

Filter(Table, OR(AND([Category] = "NO" , [Day Segment] = "Weekend") , AND([Category] = "NO" , [Day Segment] = "Working Day")))

Br,
J