How to Count records and partition by a column
Hi Community, I am trying to do a count partitioned by date and area as shown below: Currently using a formula to get the count selected: CountSelected = CALCULATE(Count(table[rows]), ALLSELECTED(table)) I have tried using ALLEXCEPT function which somewhat works but that ignores my slicer selection unless im using it wrong. Thanks in advance
