Actual Total And Power BI Total is showing Difference

[AlanP514]

Hi, all Based on this Screenshot which I attached here. power BI and Actual calculation is showing differences.
For Dax, I used  this measure only 

DISTINCTCOUNT ( 'Data'[Model Number] ). This model number is in text format only 
I want to return The actual total

Execpting the solution for resolution ths

[Jihwan_Kim · Accepted solution]

Hi,

I assume some of the same model numbers are in two or more executive categories.

Please check this.

However, even the above assumption is true, but you still want to show 427, please try writing the below measure.

New measure: =
SUMX (
    ADDCOLUMNS (
        VALUES ( 'Data'[Executive Category] ),
        "@distinctcount", CALCULATE ( DISTINCTCOUNT ( 'Data'[Model Number] ) )
    ),
    [@distinctcount]
)