Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Create Calculated Table Showing Values From Measure if Filters Match

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

 

 

Need Help
  • suparnababu8's avatar
    suparnababu8
    1 year ago

    Hi Anonymous 
    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.

     

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago
    Create Calculated Table Showing Values From Measure

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

     

    What are you trying to achieve?

  • suparnababu8's avatar
    suparnababu8
    Super User
    1 year ago

    Hi Anonymous 
    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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

       

      Hi,

       

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

       

      Thanks...tksnota

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous ,

     

    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