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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How to calculate COUNTA like in Excel for a Visual Table with a field which is a Measure

How calculate COUNTA like in Excel of a Visual Table when my fields are mixed between Tables and Measures?

 

Below I have a Matrix Visual which is built with a Sin Table, a Year Table and a Measure which is the variance between two other tables. I apply a filter so that the table does not show me any zero amounts. How to obatin a COUNTA of my SIM Column? My count should result in 9.

 

Capture.JPG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Instead of using a measure, I simply added another SIN Column as a Distinct Count and it gave me my SIN Total.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Instead of using a measure, I simply added another SIN Column as a Distinct Count and it gave me my SIN Total.

pranit828
Community Champion
Community Champion

Hi @Anonymous 

Use

CALCULATE(COUNT('table'[SIN Table'),'table'[measure variance amount] <> 0)





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile
Anonymous
Not applicable

Hello This is not working 

Variance SIN Count = CALCULATE(COUNT('Table SIN Revised with Manual Adj'[SIN]),'Measures YE Reconciliation'[Variance Prod File - Rev CSLS] <> 0)

I get this error messsage: A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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