Forum Discussion
Count Days from a Table
Hello, I have a requriement to capture how many days a rep is active per month. The rep can have multiple rows in a single day as there are other fields (such as status and categories etc). ...
Hi,
Try this. Drag Rep to the table visual and write this measure
=distinctcount(data[date])
Hope this helps.
Ashish_Mathur , is there a way to achieve this without displaying the Rep Name. There is a visual need to do a company target and dept target. So i should get 13 for the month and display just that value on a card or subsequent visuals with further calculations.
Hi,
Remove Rep from the visual and change the visual to a card visual.