Forum Discussion
How to create a measure that sums per attribute value when more than one table is involved
The solution to the measure for this case is as follows:
SumOfSales_Category =
VAR Cat = MAX(Bookings[Category])
VAR SumOfCategory = CALCULATE ([Sales (USD)], FILTER (ALLSELECTED ('Bookings' ), Bookings[Category] = Cat))
Return SumOfSales_Category
I have my Power BI report ready and I've put it out on my OneDrive, in a subfolder I just created for this .pbix file. However, I'm not sure how to share it with you. If you could please advise how I go about doing that.
Thank you.
Community SupportHi SBell65 ，
Right click on the .pbix file in onedrive then choose "share":
Then choose "anyone with the link">"apply":
Finally you will get a link,just share the link with us.
Kelly
Thank you for the reply. Unfortunately, our company has secured that function and is not available for use. Is there any other option available to me to get you my .pbix file?
The solution to the measure for this case is as follows:
SumOfSales_Category =
VAR Cat = MAX(Bookings[Category])
VAR SumOfCategory = CALCULATE ([Sales (USD)], FILTER (ALLSELECTED ('Bookings' ), Bookings[Category] = Cat))
Return SumOfSales_Category
- StidifordN
Helper III
So happy to have found this response - its taken me a good few hours of different phrases to find the right solution to this problem. 🎉
- Ashish_Mathur
Super User
Hi,
Put it up on Google Drive and share the expected result very clearly.
