need to turn a range of summarize counts into a matrix or similar visual

[bsheffer]

I have this measure:   [_consecutive_months_seasonal]

which gives the number of consecutive months that a merchant has been seasonal.  My client wants a visual that displays a number of range of 1-32 and the distinct count of merchants that had that number of consecutive months.  I don't have a table with that range of numbers and cannot add it to the published datasource.

this measure gives that count for a specified total

_test = countrows(filter(SUMMARIZE('Fact MID_Status_History', 'Fact MID_Status_History'[MERCHANT_NUMBER], "consecutive_months", [_consecutive_months_seasonal]), [consecutive_months] = 32))

the result I want is

1   2   3   4   5   6  7   8   9   ... 32

15 10 12 20 55 2  21 50 75 ...  60

I could create 32 of these and mash them into a multi row card.  Is there a slick method of doing this instead?

[v-henryk-mstf]

Hi @bsheffer ,

Each card visual can only display a single calculation result. You can create a formula and use allexpect(table[consecutive_months]) to keep this grouping condition. The results under different groups can be displayed in the table or matrix.

If the problem is still not resolved, you need to provide some information according to the following rules, otherwise I cannot do further testing.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bsheffer · Accepted solution]

Tried it with the brute method of 32 measures but they wouldn't filter the content on the rest of the page.

So we turned the _consecutive_months_seasonal into a calculated column in the merchant table and then created a matrix with that column and count of distinct merchants.  That also allowed us to click on a value and filter the other visuals by the merchants that qualified under that count.