Forum Discussion

katromank's avatar
katromank
Frequent Visitor
2 years ago
Solved

Totals Aggregation Issue

Hi, I have a issue in my report.

 

I have two measures,

 

UDR = Product Sales/ Stores Count - Sales per day per restaurant 

UPT = Product Sales/(Transactions/1000) - Sales per 1000 Transactions

 

Product sales was in 01.01.2024-14.01.2024 

 

There is a condition on the report that sales >0 so selecting the dates 01.01-2024-31.01.2024 shows only the days from which there are sales and calculates UPT and UDR correctly.

unfortunately when I delete the date it shows UPT AND UDR calculated for the whole period .

what is wrong:/

What can I do to show the correct value for the total -only from the days in which there were sales of the product.

 

Could you please help me:)

Thanks in advanced,

BR

KRK

Need Help
Tips and Tricks
  • tharunkumarRTK's avatar
    tharunkumarRTK
    2 years ago

    katromank 

     

    You can download the pbix file from here

     



    Need Power BI consultation, hire me on UpWork .


    If the post helps please give a thumbs up



    If it solves your issue, please accept it as the solution to help the other members find it more quickly.




    Tharun



5 Replies