Forum Discussion

ReadTheIron's avatar
ReadTheIron
Helper III
4 years ago

Create table based on Count Of another column

I have created a matrix with a simple Count Of column. The rows are Equipment Description, the values Count of Date Reported. I've then filtered Count of Date Reported to greater than or equal to 10.

 

 

Is there a way to create a table listing the rows of Equipment Description produced by this filter, so I can go on to create other visualization using just that list? Worst comes to worst I can export it out and export it back in, but I'd like something dynamic if possible, since data will keep being added to the original table.

Need Help

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi

     

    You can create a measure to exclude descriptions with less than 10 counts.

     

    CALCULATE(
    [Count of Column],
    FILTER(
        your_table,
        COUNTROWS(your_table) > 10
        )
)

     

     

    Kind regards,
    José
    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! 🙂

    • ReadTheIron's avatar
      ReadTheIron
      Helper III
      4 years ago

      When you say

      CALCULATE(
    [Count of Column],

      what's [Count of Column] supposed to be? Is it the name of the column I'm counting [Date Reported]? It won't let me enter a column name, only a table name.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I tought it was a measure.

        A best practive would be to create that "Count of Date Reported" in a power bi measure.

        Otherwise you could just do this, as calculate needs an agregation funcion

         

        CALCULATE(
    SUM(table[Count of Column]),
    FILTER(
        your_table,
        COUNTROWS(your_table) > 10
        )
)

         

        Kind regards,
        José
        Please mark this answer as the solution if it resolves your issue.
        Appreciate your kudos! 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi ReadTheIron,

    Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.

    If these also don't help, please share more detailed information to help us clarify your scenario to test.

    How to Get Your Question Answered Quickly 

    Regards,

    Xiaoxin Sheng