Forum Discussion

SBell65's avatar
SBell65
Frequent Visitor
6 years ago
Solved

How to create a measure that sums per attribute value when more than one table is involved

I am trying to create a measure that provides a sum based on each value of a single attribute.  In this case, the "Category" column. The grid in question is shown below and contains data from four di...
Need Help
  • SBell65's avatar
    SBell65
    6 years ago

    v-kelly-msft BA_Pete 

     

    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

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi SBell65 ,

 

I guess the issue happens in the measure of [Sales Amount],based on the data you provided,I feel a bit difficult to get the output,so if it's available,could you pls upload your .pbix to onedrive business and share it with us?Remember to remove the confidential information.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
 
  • SBell65's avatar
    SBell65
    Frequent Visitor
    6 years ago

    v-kelly-msft 

    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.

     

    • v-kelly-msft's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi 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.

       

      Best Regards,
      Kelly
      Did I answer your question? Mark my post as a solution!
      • SBell65's avatar
        SBell65
        Frequent Visitor
        6 years ago

        v-kelly-msft 

         

        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?