Occasional Visitor
Posts: 1
Registered: ‎01-11-2019


[ Edited ]
Senior Member
Posts: 255
Registered: ‎02-14-2017

Re: Distinct Count Total Incorrect

To help, need to see layout (what is on rows, columns),  and possibly tables & relationships.

Super User
Posts: 3,748
Registered: ‎01-14-2017

Re: Distinct Count Total Incorrect



I will need to see your PBI file.  Share the link from where i can download it and clearly show where the result is incorrect.  Also, let us know what exact answer are you expecting there.


By the way, you do not need the CALCULATE function there.  Just =DISTINCTCOUNT('TableA'[CustomerName"]) will do.

Community Support Team
Posts: 2,221
Registered: ‎02-06-2018

Re: Incorrect




You may forgot to post your issue, could you post the description of your issue and sample data?



Jimmy Tao