Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to create a Daily report?

I currently have a few report pages that show the analytics of tickets in the company. In the current business we have tickets coming through every day. I'm trying to create a page for daily repor...
Need Help
Tutorial Requests
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

     

    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/

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

Thank you for your feedback.

Instead of using the Quick Measure Function, how about trying to write by yourself?

I am not quite familiar with using the Quick Measure Function, because I did not try to use it....

 

You can use TODAY() function when you write the measure by yourself.

 

Try to write something like below.

 

Newmeasure =
CALCULATE (
[your measure],
FILTER (
ALL ( DateTABLE ),
[datecolumn]
>= TODAY () - 1
&& [datecolumn] <= TODAY ()
)
)

 

Or, if it is OK with you, please share your sample pbi file, then I can try to come up with a more accurate measure.

 

thank you.

 

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/

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi, Jihwan_Kim 

I can't send a template with it being sensitive client data, but thank you for the offer. However, this is the full daily report page I'm constructing with the dataset on the right side: 

I tried your new measure, however, there was an issue. 

Newmeasure =
CALCULATE (
[your measure],
FILTER (
ALL ( RequestDetails ),
[Created Time]
>= TODAY () - 1
&& [Created Time] <= TODAY ()
)
)

 

The [your measure] wasn't working as it was trying to detect another measure, but I don't have another measure. (One that's relevant to this that is). 

 




  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    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 ()
    )
    )

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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? 

       

       




      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        5 years ago

         

        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/