topic Mistery Unsolved in DAX Commands and Tips

Mistery Unsolved

BeginnerBI — Wed, 21 Dec 2022 21:35:46 GMT

Re: Mistery Unsolved

v-easonf-msft — Tue, 13 Dec 2022 07:52:20 GMT

Hi, BeginnerBI

It is not clear about your needs, please provide a more specific explanation.

Best Regards,
Community Support Team _ Eason

Re: Mistery Unsolved

BeginnerBI — Tue, 13 Dec 2022 21:13:27 GMT

the problem is that China is suppose to appear once WHEN we filter it by the Goal '18', but when we add it the yellow columns expand the same value.

it should display;

China | 4 | 599854FJ | 18 | 96 | 480.53 | 5.265 | 63 | 708.5

We have days trying to figure it out. The relationships, the columns format, the slicers, etc but the most important it is a big report with multiple tabs so rebuild it doesn't look like an option. thank you!!