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,

 

Calculated table is initialized once you create it. It values won't be dynamically changed according to slicer selection. Only measures can return dynamical values.

 

Why do you need to create such a table? What is the usage in other context? If you want to count the entries of Table "Pizza ingredients" against the slicer filter, you could directly use this measure:

Count rows=COUNT('Pizza ingredients'[Ingredients])

 

Best regards,

Yuliana Gu

Kontrast's avatar
Kontrast
Frequent Visitor
8 years ago

Thank you for your reply.

 

I want to compare the selected ingredients with other data. 

 

For example comparing them with a table who shows the offer of a supplier. 

The Goal is to select a pizza -> get the ingrendients -> compare them with the offer of the supplier -> and then show if the different ingredients of the selected pizza are available by the supplier. 

 

Comparing the ingredients isn't the problem but working with dynamically filtered Table doesnt work. 

As you said "Calculated table is initialized once you create it", i always grab the hole table with the *Pizza+ingredients[ingredients]* and not the selected ones. 

 

Best regards

Kontrast

  • 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