Forum Discussion
Count Data based on Filter
Anonymous
If you date is connected to Date calendar you put that on any visual any of the fields from the sales table and change aggregation on the fly by right click on the field in the visualization pane
Or create like
Cnt = count(table[Cust Id])
Dis Cnt = distinctcount(table[Cust Id])
Cnt = count(table[AgentId])
Dis Cnt = distinctcount(table[Agent Id])
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/