Create table based on Count Of another column

[ReadTheIron]

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.

[v-shex-msft]

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

[jcalheir]

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]

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.

[jcalheir]

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! 🙂

[ReadTheIron]

Count of Column is not a column in any table, it's created in the Values box of the Matrix visualization from choosing Count on the Date Reported column. I guess I'm asking how to do that as a measure.

[jcalheir]

Can you provide some sample data? So we can evaluate if we can create a measure to help you?

[ReadTheIron]

I appreciate the assistance! Here's my sample data, my current matrix visualization, and the sort of visualization I want.

Essentially, I'm trying to do a deep dive on assets that have a high number of incidents, looking at the causes (and other things, but no need to complicate the example) of only those assets.

Right now, if I create a matrix with Asset and Cause as the rows and Count of Date as the value, when I try to filter Count of Date by greater that or equal to 3, Switch1 disappears.