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

[Anonymous]

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 ?

[v-xicai · Accepted solution]

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.

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.