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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
quickcreator
Helper I
Helper I

Count Rows (not in a table)

I've made a matrix with measures. The base column is by date. However, there is a date slicer. Count rows works on that. However, when I put a filter on the dates to remove the blanks & the 0's from the measure, count rows does not change. Any help would be greatly appreciated.

 

Picture1.png

 

 
 
 
 
 
 
3 REPLIES 3
iamprajot
Responsive Resident
Responsive Resident

What is the MTD DAX formula and Measure formula used?

It is a measure (A+ B)/C on

several measures, from diff tables:

A = Calc(sum(TableA[Col A])) 

B = Calc(sum(TableB[Col A])) 

C = Calc(sum(TableC[Col A])) 

 

Hi @quickcreator ,

Can you please share a dummy file? You could upload it to OneDrive for Business and post the link here. Then we will understand clearly.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.