How to show dynamic Table/Matrix containing only measures that interacts with slicers?

[akumarshekhar]

My data is like this: Customers may face some interruptions which is logged as a incident number on a given date.

Customer Name        Incident Number     Incident Date

A	101	Jan-23
B	ab223	Jan-23
B	cd112	Oct-23
B	1083	Feb-24
B	abc	Mar-24
C	444	Feb-24

I want to create a stacked column chart (or even a table/matrix would work) that shows Number of Customer on Y axis and number of Incidents on X axis. so the output (in a tabular format) would be  something like this (only first 2 columns):

#CustomersAffected	#Times	Explanation
1	4	This is for B (1 customer experienced incidents 4 times)
2	1	This is for A and C (2 customers experienced only 1 incident)

This matrix needs to respect the date slicer which is in the report page. I am not able to create the chart since any measure cant be put in X axis, same for matrix (can't put measure in Rows). I can create calculated column that calculates the numbers but it wont respect the slicer selection.

Any help is highly appreciated. Thanks.

[akumarshekhar]

@Ashish_Mathur  - This works absolutely fine for my model. Many thanks.

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[lbendlin]

 I am not able to create the chart since any measure cant be put in X axis, same for matrix (can't put measure in Rows)

That is correct, Power BI does not have the LOD features.  You need to bring your own buckets (ie a table with incident counts) and then map your measures to that table.  You can put the table column in your chart axis.