My table is not summing correctly

Hi jonnyA ,

 

How is your model setup?  How do you have the relationship between the tables, this is context related but without further information is difficult to pin point the error.

 

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

Hi jonnyA ,

Please try to create new measure as below to replace the measure [Count of CPT's] on the visual in order to resolve the incorrect total values:

Count of CPT's = DISTINCTCOUNT ( 'Table'[CPT's] )

Measure =
SUMX (
    GROUPBY (
        'Table',
        'Table'[Provider Name],
        'Table'[CPT Code],
        'Table'[DOS].[Month]
    ),
    [Count of CPT's]
)

In addition, you can refer the method in the following videos to resolve it.

Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand

Dax for Power BI: Fixing Incorrect Measure Totals

If none of the above ones is working for your scenario, please provide some sample data of involved fields on the visual. Please also share the related relationship info if the involved fields are from different tables and exist any relationship. Thank you.

Best Regards

Hi @jonnyA ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem with yours. Thank you.

Best Regards