0

I have a Power BI report with two tables in it. Table_1 looks like this:

Tariff_name ID
Tariff_1 ID1
Tariff_2 ID2
Tariff_3 ID3

Table_2 looks like this:

Tariff_name ID
Tariff_33 ID2
Tariff_44 ID1
Tariff_55 ID3

Tables join by ID column with many to many and both selection.

I have made two slicer for these two tables.

Now I want that, while I select any tariff from the first table, the shape (card, textbox or another) show alternative tariff from table_2.

I have written this code but gives blank:

Selected Table_2 Alternative =
VAR SelectedID =
    SELECTEDVALUE(Table_1[ID])
RETURN
IF(
    NOT ISBLANK(SelectedAlternativeID),
    CALCULATE(
        SELECTEDVALUE(Table_2[Tariff_name]),
        Table_2[ID] = SelectedID
    ),
    ""
)

How can I solve this?

Improve this question
New contributor
Feda_khf is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
2
  • could you pls clarify the expected output? when you select T1 , you wan tot see T44? Commented yesterday
  • yes sure. while select Tariff_1, want to see Tariff_44 which both of them are same ID Commented yesterday
Related questions
1
Power BI: How to return values from one table based on slicers referencing another table?
1
Dynamic Filtering of Calculated Table Not Working with SELECTEDVALUE(slicer) in Power BI
2
Need help in filtering using measure in power bi
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.