Distinct count rows that are not blank matrix

[Anonymous]

Hi, 

I would like to count the number of non blank values in a matrix.

Values of the matrix are based on a measure.  

Tnx for help:)

[mccville]

Great question - great solution!  this community rocks!

[Zubair_Muhammad]

@Anonymous 

Try this MEASURE

Measure =
COUNTROWS (
    FILTER ( ALLSELECTED ( TableName[ColumnName] ), [Measure] <> BLANK () )
)

[Anonymous]

The measure works fine! Tnx  @Zubair_Muhammad 

But is it possible show the count as 1 per value and not sum count of values <> blank on every value. And sum count on the higher level of the matrix.

My matrix has 3 levels.

[Zubair_Muhammad · Accepted solution]

Hi
Try replacing Allselected with VALUES in the above formula

[Anonymous]

@Zubair_Muhammad Works like a charm!!!!!!!!

Super tnx!