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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
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

Kontrast's avatar
Kontrast
Frequent Visitor
8 years ago

Hey v-yulgu-msft

 

mhh ok then i have to find another way to dynamically compare my Tables.

Maybe this is an idea for some propective updates in Power BI :D  Would be really helpfull. 

 

Thank you for your help!

 

Best regards 

Kontrast