topic Re: Bar Chart and Table Chart not showing correct values - DAX help in DAX Commands and Tips

Bar Chart and Table Chart not showing correct values - DAX help

PBIfolks — Fri, 21 Apr 2023 08:31:28 GMT

Hello All

I require assistance with a Measure calculation in Power BI.

Currently, the Bar Chart and TABLE A calculation are accurate, however, the values in Table B are not displaying correctly. For instance, when I select S06, the value in TABLE A is 8, whereas TABLE B is displaying an incorrect value of 2.

PBIX FILE ATTACHED

The desired logic is to count S06 from Primary Code when I filter the Calculated Column [Section A] P1, and to count S06 from SecondaryCode when I filter the Calculated Column [Section B] P1. The intention is to capture the complete list of codes from both PrimaryCode and SecondaryCode columns.

Any assistance in this matter would be greatly appreciated.

Re: Bar Chart and Table Chart not showing correct values - DAX help

scott_henderson — Fri, 21 Apr 2023 09:07:06 GMT

What is the desired outcome for S06 P 1 in table B... should it be the toal of 10 or are you expecting something else ?

Re: Bar Chart and Table Chart not showing correct values - DAX help

PBIfolks — Fri, 21 Apr 2023 09:27:06 GMT

S06 in Table b = 0

Logic when you filter Section B COL by P1, on the secondary code their is 0 value against S06. Thanks

Re: Bar Chart and Table Chart not showing correct values - DAX help

scott_henderson — Fri, 21 Apr 2023 09:33:24 GMT

Section B column has 2 Values that return P 1 ?

Re: Bar Chart and Table Chart not showing correct values - DAX help

PBIfolks — Fri, 21 Apr 2023 09:51:18 GMT

On this screenshot when you select P1, in the secondary column you have 0 value for S06. hope this clarifies....

Re: Bar Chart and Table Chart not showing correct values - DAX help

scott_henderson — Fri, 21 Apr 2023 10:06:33 GMT

As the model shows, you will never have a value of Zero as there are 2 entries for S06 and P 1 ?