Help with filtering distinct count of column by a measure

[micpete]

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,

[micpete · Accepted solution]

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

That seems to work!

[mark_endicott]

@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.