topic DistinctCount with selected Filters in Filters Pane in DAX Commands and Tips

DistinctCount with selected Filters in Filters Pane

Anonymous — Thu, 02 Mar 2023 22:24:04 GMT

Hello,

I have a measure with distinctcount. When I select a part of a bar chart visual or select a filter in the righthand filters pane, the measure does not perform the distinctcount on the selected values.

EventCount=Calculate(DistinctCount('tickettable'[ticketnumber]))+0

Any thoughts/ideas...thank you!

Re: DistinctCount with selected Filters in Filters Pane

FreemanZ — Thu, 02 Mar 2023 23:47:09 GMT

hi Anonymous

how does the selected column related to the ticketnumber column?

Re: DistinctCount with selected Filters in Filters Pane

Anonymous — Thu, 02 Mar 2023 23:59:37 GMT

Sharing in case others need help .. I just had to add the following to get it to work:

EventCount=Calculate(DistinctCount('tickettable'[ticketnumber]),ALLSELECTED('tickettable'))+0

Thank you!