topic Re: Help with filtering distinct count of column by a measure in DAX Commands and Tips

Help with filtering distinct count of column by a measure

micpete — Wed, 05 Jun 2024 07:54:09 GMT

Hello,

Can anyone help me here? I have a column with a bunch of names, some of the names are duplicated but I just want the distinct count of those names, I want to filter these names by a measure I created that I know works, can I create another measure to find the distinct count of these names filtered by that measure? I can't seem to find anything that works,

Re: Help with filtering distinct count of column by a measure

mark_endicott — Wed, 05 Jun 2024 11:41:41 GMT

micpete - If you have a measure like:

DISTINCTCOUNT( Name )

Then you can add it to a visual as a visual filter, and select "Is Not Blank"

But you will only be able to take this approach should there be a column from your data in the visual.

If this helps you, please mark it as the solution.

If it does not, please provide more detail about what you are trying to achieve, some sample data and the measures you are using.

Re: Help with filtering distinct count of column by a measure

micpete — Tue, 11 Jun 2024 08:30:30 GMT

Hello, I think I've managed to achieve it by using Calculate(DistinctCount('ColumnName'), Filter(AllSelected('ColumnName'), 'Measure'))

That seems to work!