Forum Discussion

pieterhkruger's avatar
pieterhkruger
Frequent Visitor
7 years ago
Solved

Total by date category

Hi,   Using the following sample data: Date Group FILTER 01-May-19 A Filter group 1 01-May-19 A Filter group 2 01-May-19 A Filter group 1 01-May-19 B Filter group 1 01-...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, pieterhkruger 

    Just try this formula to add a measure

    Measure = CALCULATE(COUNTA(Table1[Group]),ALLEXCEPT(Table1,Table1[Date]))

    Result:

     

    Best Regards,

    Lin

jthomson's avatar
jthomson
Solution Sage
7 years ago

Use countrows on the table the same way you'd make the first column, but you want to apply allexcept to the date column - this'll make the calculation disregard the group (and anything else for that matter) but still split it by date