Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Count Data based on Filter

Hello - I'm sure this is simple but I'm stumped.  Below is some sample data:   Agent ID Cust ID Sale 1 1 3/1/2020 1 2 3/2/2020 1 3 3/3/2020 1 4 3/3/2020 1 5 3/4/2020 ...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ，

 

Drag  column Sales of  the table to a card visual, right click the field and choose" count":

Or you can create a measure as below:

 

measure = CALCULATE(COUNTROWS('Table'),ALLEXCEPT('table 2','table 2'[Date]))

 

Then put the calendar date to a slicer :

Finally you can fulfill what you need.

 

Here is the related .pbix file.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!