Forum Discussion

Kontrast's avatar
Kontrast
Frequent Visitor
8 years ago
Solved

Operations on filtered Tables

Hello :)    I've created two connected Tables. (1:n) The First one is shown as a "Donut Chart". So when i select ohne Part of the "Donut" the second table gets filtered by the selected value in th...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Kontrast,

     

    Yes, we are not able to list the different ingredients in a new table dynamically. As a workaround, you could try below measure to calculate the number of different records between the selected pizza and the offer of the supplier:

    Difference =
COUNTROWS (
    EXCEPT (
        VALUES ( 'Pizza&ingredients'[ingredients] ),
        VALUES ( supplier[ingredients] )
    )
)

    Best regards,

    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Kontrast,

 

Can you post a sample data and your data relationship? 

 

Regards,

Carlos.

 

Kontrast's avatar
Kontrast
Frequent Visitor
8 years ago

Sure, here is an Example.

 

I clicked on the "Frutti di mare" row. 

The Table "Table" gets the informations from the Table "Pizza ingredients" but loses the filter.

 

The result I whised were that the Table "Table" showes only the ingredients of the Frutti di mare Pizza, so i can work with the same data in an other Context. So the Table "Table" is like a Copy of table "Pizza+Ingredients".