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 the Chart. 

 

Now i want to count the entries in the filtered Table but he always counts all the entries existing in the table without any filter.

 

For Example i have one Table (Name of Pizza) and another Table where for every Pizza the different ingredients are listed. Now, when i chose in the first Table "Magherita" the second table shows the ingredients of a magherita Pizza. But doing the Count operation returns the number of ingredients of all available Pizzas. 

 

How is it possible to only work with selected entries in a table ? 

 

 

Regards 

Kontrast 

  • 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

6 Replies

  • 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".

       

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