Turn a calculated measure into a row in a matrix

[Domstadfoppe]

Hello,

I want to use the outcome of a calculated measure as a row in a Matrix.

I counted how many asbestos containing applications we found per object and made the following calculation:

Asbesthoudende toepassingen =

CALCULATE(

    COUNTA('Application'[Id]),

    'AnalysisResult'[Asbestos] IN { TRUE }

that resulted in a table where i could see how many asbestos containing applications (Asbesthoudende toepassingen) we found per object:

Object ID	Asbesthoudende toepassingen
1	1
2	0
3	2
4	0
5	0
6	0
7	1
8	3

What i now want is a table where i can use "asbesthoudende toepassingen" as rows, and count how many "object ID" have that many asbestos containing applications. Something like this:

Asbesthoudende toepassingen	Count of Object ID
0	4
1	2
2	1
3	1

PowerBI won't let me use a measure as a row in a matrix. Does anyone know how to do this?

Many thanks.

Pim Versteegt

[amitchandak · Accepted solution]

@Domstadfoppe , I think you need dynamic segmentation/binning using independent table

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
https://youtu.be/CuczXPj0N-k

[Domstadfoppe]

thank u @amitchandak. Thanks to the video i made the table i needed.