cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wayers Member
Member

DAX Calculation with Multiple Slicers and Tables

Community, 

I am seeking help with a calculation (the DAX) that includes using a slicer and multiple tables. I hope that I have provided enough information to get the help I need.

 

The calculation we are seeking is to multiple the "Raw Data" in Table 1 by a "Multiplier" in Table 4. The multiplier is determined by the "Multiplier ID" in Table 4 selected in a slicer of  "Multiplier ID" in the table.

 

Data Model Information:

Below are the tables and relationships used in this example.

Table 1 Data ID is related to Table 2 Data ID

Table 2 Attitude ID is related to Table 4 Attitude ID

Table 3 is not used in the example

TableWT.JPG

 

 

 

In this example "Attitude ID" 1,2,and 3 can use "Multiplier ID" 1 or 2, I'm trying to use the slicer to select which "multiplier" is used on each the "Raw Data" based on the "Attitude ID".

 

Below is what I would like to return;

In Table 1,  "Data ID" 1 and 5 share the same "Attitude ID" (1) in Table 2,

in Table 4 "Attitude ID" 1 can use "Multiplier ID" 1 or 2.

If I have a slicer of the "Multiplier ID" and select 1,

the calculation (named DataMultiplies) for "Data ID" 1 should return 5 (25*0.2, "Raw Data" * "Multiplier") and for "Data ID" 5 should return 9 (30*0.3, "Raw Data" * "Multiplier")

 

Any help with the DAX for this is greatly appreciated!

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: DAX Calculation with Multiple Slicers and Tables

@wayers use following measure

 

Raw data x multipler = SUM( 'Table 1'[Raw Data] ) * MAX( 'Table 4'[Mupltipier] )





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

6 REPLIES 6
Super User
Super User

Re: DAX Calculation with Multiple Slicers and Tables

@wayers if you can share your sample data in pbix file using one drive/google drive, I will get you the solution.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





wayers Member
Member

Re: DAX Calculation with Multiple Slicers and Tables

@parry2k ,

 

Click below for BI file

 

Test BI File

wayers Member
Member

Re: DAX Calculation with Multiple Slicers and Tables

@parry2k 

 

Link to PBIX file (first post incorrect)

 

Click Here

Super User
Super User

Re: DAX Calculation with Multiple Slicers and Tables

@wayers hey try to download the file but taking forever. you can send it by email and emai address is in my signature.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Super User
Super User

Re: DAX Calculation with Multiple Slicers and Tables

@wayers use following measure

 

Raw data x multipler = SUM( 'Table 1'[Raw Data] ) * MAX( 'Table 4'[Mupltipier] )





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

wayers Member
Member

Re: DAX Calculation with Multiple Slicers and Tables

@parry2k ,

Thank you so much for the help on this!!

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)