Forum Discussion

mahra-in's avatar
mahra-in
Helper II
8 years ago

Measure for sum when match between two tables

I have two table with related columns and perform action   Table 1 (Spend):   Category Supplier Spend Motor ABB 5000 Drive ABB 6000 Drive Siemens 8000 Cable ABB 9000 M...
Need Help
ccakjcrx's avatar
ccakjcrx
Resolver I
8 years ago

Hey mahra-in!

 

Here is a screenshot of my solution:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Here is the measure I used:

 

MsrSUMMatch = 
CALCULATE(
    SUM(Spend[Spend]),
        FILTER(Spend,
            Spend[Category] = RELATED(PreferredSupplier[Category])
            && Spend[Supplier] = RELATED(PreferredSupplier[Supplier])
        )
)

 

The percentage measure is as follows:

 

MsrSUM% = 
DIVIDE([MsrSUMMatch],SUM(Spend[Spend]))

Click HERE to access my .pbix file. 

 

I hope this helps! Have a good weekend.

mahra-in's avatar
mahra-in
Helper II
8 years ago

Hi

 

Sorry I missed to mention the Table 1 & Table 2 are not directly related since both tables has category repeated and hence I had created a bridge table to relate these tables

 

Now when I apply the measure you sent me the related is not working

 

Can you help me on that.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi mahra-in,

     

    I do not know whom you are replying to but did you try my solution?