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 IV
Super User IV

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 IV
Super User IV

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

Highlighted
Super User IV
Super User IV

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 IV
Super User IV

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors