Not display any data if one of the category count value is < 5

[bharosha]

I am trying to get get my visualization to not show any data if one of the category breakdown value is < 5. 

For an example, below is my table. 

Aggregate count values are below

Upon selection of other filters, when the table value becomes below (one of the category values <= 5), I do not want the table to display any values at all. 

[Gabry]

Hello,

not sure to have understood properly.

Measure = minx(summarize(table, category, "Rowcount", count(id)), [Rowcount])

Then in the filter of the visual you put this measure and you select >= 5

I think this should work, let me know, bye

[bharosha]

@Gabry , With this only the category value which has less than 5, value gets filtered out. I wanted all the data to not show. 

Below is the table with you solution

Only the category A gets filtered out, I wanted if one of the category count is <=5, nothing should show like below

[Gabry]

ok adjust like this

Measure = IF(MINX(SUMMARIZE(ALL('Table'),'Table'[Categori],"RowC", COUNT('Table'[ID])),[RowC])<5,1,0)

@bharosha  I just edited the answer, and tested this measure it works. Please mark as accepted solution

it works also with this measure

Measure = MINX(SUMMARIZE(ALL('Table'),'Table'[Categori],"RowC", COUNT('Table'[ID])),[RowC])

then put in the visual filter, measure>= 5

[bharosha]

@Gabry , it does not work, measure value shows always 0.

[bharosha]

@Gabry  see screenshot, not data measure always display 0. 

[Gabry]

Man if you want to use filter on the same table you need to adjust the measure like this

Measure = MINX(SUMMARIZE(ALL('Table'[category]),'Table'[Category],"RowC", COUNT('Table'[ID])),[RowC])

Put the ALL statement just on the column category and not on the whole table

[Gabry]

Only if there's one category <5.

Tested again and it works:

[bharosha · Accepted solution]

@Gabry , 

below worked

Measure = MINX(SUMMARIZE(ALLSELECTED('Table'),'Table'[Categori],"RowC", COUNT('Table'[ID])),[RowC])