Forum Discussion
How to create a Daily report?
Hi, Anonymous
Thank you for your info.
In this case, I think you also need to write the measure for Count Ticket.
I am not sure how you count Tickets, but I assume something like counting the number of rows in the table.
In this case, try to write something like below.
Newmeasure =
CALCULATE (
countrows(RequestDetails),
FILTER (
ALL ( RequestDetails ),
[Created Time]
>= TODAY () - 1
&& [Created Time] <= TODAY ()
)
)
Hi, Jihwan_Kim
Thanks again for the help, it does count tickets by row you are correct. So if there are 6 rows that are assigned to a specific account, that will be 6 tickets displayed.
Anyway, I put this into practice, however it didn't have the effect I thought it would have and I'm quite baffled with the result. I'm not sure how this happened, it now has 14 tickets for each account displayed?
Hi,
in the measure,
ALL ( RequestDetails ) => removes all filters in the table.
please try to replace the above with the below.
ALL ( RequestDetails[CreatedDateTime] ) => removes the filter only in the specific column
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/Thank you very much Jihwan_Kim I appreciate the help, accepted as best answer.
I was really confused by that last visual representation, but you've solved it 🙂