Forum Discussion

quickcreator's avatar
quickcreator
Helper I
6 years ago

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.

 

 

 
 
 
 
 
 
Need Help

3 Replies

  • iamprajot's avatar
    iamprajot
    Responsive Resident
    6 years ago
    What is the MTD DAX formula and Measure formula used?
    • quickcreator's avatar
      quickcreator
      Helper I
      6 years ago

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

       

      • v-xuding-msft's avatar
        v-xuding-msft
        Community Support
        6 years ago

        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.