Forum Discussion
Jacks060650
2 years agoFrequent Visitor
Helping counting entries
Hello, I currently have a table with dates ( please see attached), I would like to count how many entries per date to put it onto a card visual so I can see how many lates for example we had on ...
Jacks060650
2 years agoFrequent Visitor
It looks a good way however the card I would like it just showing the number for the day. (Please ifnd attached image)
For example I have taken 23 sick calls today and if i filter it by date on the image it will let me see that 23 people called in sick, if that makes sence?
Jihwan_Kim
Super User
2 years agoHi, Thank you for your message.
I think the solution is related how you model your data, because I think, it shows count of rows in the fact table.
Please share your sample pbix file's link here, and then I can try to look into it to come up with a solution.
Thanks.