Create Calculated Table Showing Values From Measure if Filters Match

[tksnota]

Hi,

I need some help.

I have 2 tables with different classifications as shown.

I created 2 cards using measures. My aim is to show the values on the cards if the classifications are the same if not then the cards will show "No Match".

Thanks...tksnota

[v-mengmli-msft]

Hi @tksnota ,

How is the situation now? If you want to compare the two column values and display the matching values in the card, you can refer to the following method.

Create a new table contains all matching values.

MatchTable = INTERSECT(ALL('Table'[Column1]),ALL('Table (2)'[Column1]))

Create a measure shows all matching values on a card.

Measure = IF(ISEMPTY('MatchTable'),"NoMatch",CONCATENATEX(MatchTable,MatchTable[Column1]&" "))

Best regards,

Mengmeng Li

[suparnababu8 · Accepted solution]

Hi @tksnota 
It's atough requirmeent. But I'll give try

--> First, create a calculated table that combines the two tables and checks for matching classifications 

MatchedClassification = 
ADDCOLUMNS(CROSSJOIN('Table1', 'Table2'),
    "Match", IF('Table1'[Classification] = 'Table2'[Classification], "Match", "No Match"))

--> Create measures to display the values based on the match condition for the both cards sepeartely

Card-1 

Card1Value = 
IF(HASONEVALUE('MatchedClassification'[Match]) && VALUES('MatchedClassification'[Match]) = "Match",[PercentageClassification],      "No Match")

Card-2

Card2value = IF( HASONEVALUE('MatchedClassifications'[Match]) && VALUES('MatchedClassifications'[Match]) = "Match",[Margin Classification],     "No Match"
)

Use the above measures and let me know if it works.

[tksnota]

Hi,

Do you mean append 2 tables then take out the duplicats?

Thanks...tksnota

[suparnababu8]

yes

[lbendlin]

Create Calculated Table Showing Values From Measure

That's not something you can meaningfully do in Power BI.

What are you trying to achieve?