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

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
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