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

How to lookup field in column based on values in other columns

Say I have a table:

 

>Type      Type2         Type3  Type4       Value

> vehicle car             diesel      bmw      100

> vehicle motorbike  gasoline bmw      110

> vehicle car              diesel     ferrari    300

 

 

And I want to select with slicer Type, Type2, Type3 and Type4, and based on this return the Value, which will be used in further calculations. How would I go on about this ?

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xicai Senior Member
Senior Member

Re: How to lookup field in column based on values in other columns

Hi test_user123,

 

You can create measure using DAX function below, assume the table named Table1.

 

Measure = CALCULATE(SUM(Table1[Value]),ALLSELECTED(Table1))

 

Then ,create 4 Slicer visuals to display Type,Type2,Type3,Type4. For example, when make some selection in slicers ,the measure return the result showing in picture.

 

11.png

 

 

 

 

 

 

 

 

 

 

 

 

 

Here is my pbix test file link: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EeyQZAF9t-dClsHXCZ...

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 REPLY 1
v-xicai Senior Member
Senior Member

Re: How to lookup field in column based on values in other columns

Hi test_user123,

 

You can create measure using DAX function below, assume the table named Table1.

 

Measure = CALCULATE(SUM(Table1[Value]),ALLSELECTED(Table1))

 

Then ,create 4 Slicer visuals to display Type,Type2,Type3,Type4. For example, when make some selection in slicers ,the measure return the result showing in picture.

 

11.png

 

 

 

 

 

 

 

 

 

 

 

 

 

Here is my pbix test file link: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EeyQZAF9t-dClsHXCZ...

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.