Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Coan7
Post Partisan
Post Partisan

Distinct count rows that are not blank matrix

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:)

1 ACCEPTED SOLUTION

Hi
Try replacing Allselected with VALUES in the above formula

Regards
Zubair

Please try my custom visuals

View solution in original post

5 REPLIES 5
mccville
Frequent Visitor

Great question - great solution!  this community rocks!

Zubair_Muhammad
Community Champion
Community Champion

@Coan7 

 

Try this MEASURE

 

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

Regards
Zubair

Please try my custom visuals

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.

 

 

Hi
Try replacing Allselected with VALUES in the above formula

Regards
Zubair

Please try my custom visuals

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

 

Super tnx!

Helpful resources

Announcements
March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.