Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
PBIfolks
Regular Visitor

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

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.

5 REPLIES 5
scott_henderson
Helper II
Helper II

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

 

scott_henderson
Helper II
Helper II

Section B column has 2 Values that return P 1 ?

scott_henderson_1-1682069594947.png

 

 

 

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

scott_henderson
Helper II
Helper II

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 ?

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.