Forum Discussion
Matrix Visual - Incorrect Row header appearing under Category
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
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 TeamIf 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
2 Replies
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 TeamIf 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
Thanks Anonymous, it was a cross filtering issue.
