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
