Data showing differently on a table visual compared to clustered bar and other visuals

[Anonymous]

Hi,

I am having a random issue which I am trying to find the reason to but cannot for the last 2 days. Any pointers is much appreciated. I have a direct query running in power BI which populates the table and then i have a simple measure to get the counts.

Count of Completed CCB CNP = CALCULATE(COUNTROWS('X'),X[FA_STATUS_FLG]="C")

If I just do the count of the primary key of the table without the measure, i get a count of 116 for Aug-01 week. Also, the same number shows up when i select table display.

The moment i hit clusted column chart without changing anything else, with the same measure, the value changes to 73. The data label is not displayed as well for this column.

I checked with other viuals, and only the  PI chart shows the value as 116 and the rest all show as 73.

Am i doing something incorrectly? I need to use the clustered bar for this visual and hope to use the measure instead of the count so please suggest anything i might need to do.

Thanks,

SB

[Greg_Deckler · Accepted solution]

@Anonymous Try switching your Axis to Categorical and see what that shows.

[Anonymous]

You sir are very knowledgable.  That worked and I appreciate you responding to me. Have a great rest of your day!