Power Pivot Dax Count Does Not Match Record Count

Question

Hi all,&nbsp;Using O365.I imported 307K records from Power Platform which created a Pivot TableI&nbsp; used some formulas to tranform a bit in some blank cells&nbsp; next to the Pivot Table, I imported the samll 2 column table into Power Pivot (Data Model)&nbsp;I did some further analysis on other report and found that the 307K records was a bit small by 8K rec.I found all 315K recs, update the 2 column Excel Table, refreshed the sheet in the Data Model&nbsp;However, my CountRows Dax Formula still shows 307K rec. Why is thatThe screenshot shows the 307K rec from the Dax formula as well as the 315K rec in the status bar from the Power Pivot Window.&nbsp;Thanks,-w&nbsp;

ashish_mathur · Answer

Hi,
What measure have you written?

tecumseh · Answer

Count of group_id:=COUNTA([group_id])

ashish_mathur · Answer

Some cells in that column could have blanks.

tecumseh · Answer

It show the correct count now, maybe I am impatient?&nbsp;Thanks,-w

Forum Discussion

Related content

Pivot issue

Pivot / Unpivot?

Power BI Pivot Columns ?

Power Query Pivoting columns issue

Power Query pivot