topic Re: Matrix Visual - Incorrect Row header appearing under Category in DAX Commands and Tips

Matrix Visual - Incorrect Row header appearing under Category

rksharma86 — Tue, 16 May 2023 03:30:35 GMT

I have a issue with matrix visual, where correct visual should be one as below

Correct Visual Should be :

Category	Members	EDR % By Sector
AA	ABC	5%
	XYZ	5%
	TTQ	5%
	RFP	5%
A	UVW	3%
	XYZ	3%
	RST	3%
	WWE	3%
	YYE	3%
B	YRU	2%
	ADC	2%
	FCR	2%
	RUP	2%
	POT	2%

Visual I am getting(Incorrect)

Category	Members	EDR % By Sector
AA		5%
	ABC	5%
	XYZ	5%
	TTQ	5%
	RFP	5%
	UVW	5%
	XYZ	5%
	RST	5%
	WWE	5%
	YYE	5%
	YRU	5%
	ADC	5%
	FCR	5%
	RUP	5%
	POT	5%
A		3%
	ABC	3%
	XYZ	3%
	TTQ	3%
	RFP	3%
	UVW	3%
	XYZ	3%
	RST	3%
	WWE	3%
	YYE	3%
	YRU	3%
	ADC	3%
	FCR	3%
	RUP	3%
	POT	3%

I am using a Dax Measure to get the EDR % of Sector :
EDR % of IDR average per Category =
CALCULATE(
DIVIDE([EDR Complaint], [IDR Complaint]),
ALL('Member'[Members])
)

I noticed, if I use the Category from the members Table or calculated column(ERD % od Sector) from the Category Table I get the desired result.
What I want to know if how can I achieve this with the measure.

Please note: Members and Category are two different Dimension Table joined on Category relationship

Re: Matrix Visual - Incorrect Row header appearing under Category

Anonymous — Thu, 18 May 2023 02:43:14 GMT

Hi rksharma86 ,

Please check the relationship between the 'Category' table and the 'Member' table first. (What happens if you change the cross-filter to both?) It seems that the two are not filtered correctly.

Consider publishing a sample model, which will help locate the problem.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

Re: Matrix Visual - Incorrect Row header appearing under Category

rksharma86 — Thu, 18 May 2023 04:39:12 GMT

Thanks Anonymous, it was a cross filtering issue.