There is a discrepancy between the displayed total value and the actual value.

[Tome_05]

The total value in the attached image is 40,530, but when calculated, the true total value is 40,613. I want to correct this dissociated state.
The filter is not applied at all.
Please help someone

[Tome_05]

@Anonymous 

Thank you.
I tried it, but the numbers changed a lot and the total values did not match.
Is the formula wrong?
please tell me.

By the way, I created the formula as shown in the attached image.

[Anonymous]

Hi @Tome_05 ,

Try use KEEPFILTERS() instead of ALLSELECTED().

If it still doesn't work, please show the formula you are using.

Best Regards,

Jay

[Tome_05]

@Anonymous 

Thank you for contacting us.

I tried KEEPFILTERS but the results didn't work.

This is the formula.

Number of users = DISTINCTCOUNT (raw_data [cookie]) +0

Only unique values are displayed in DISTINCTCOUNT, and the number of people is shown in the table.

I just want to count this unique value, but the total value is 41,417.
However, as shown in the attached image, the total value is 41,334 when the value is given by DISTINCTCOUNT in the major.
In the case of the advice (new_measure) received, the total value is 87,112.
Please tell me how to put 41,417 in the total column.

I am always grateful for your help.

[Anonymous · Accepted solution]

Hi @Tome_05 ,

Strange. Please try:

new_measure =
IF (
    ISINSCOPE ( 'Table'[言語] ),
    [Number of users],
    SUMX ( 'Table' , [Number of users] )
)

If it still doesn't, please share the pbix file.

Best Regards,

Jay

[Anonymous]

Hi @Tome_05 ,

Create a new measure like below and use it to replace current measure in value field:

new_measure =
IF (
    ISINSCOPE ( 'Table'[言語] ),
    [current_measure],
    SUMX ( ALLSELECTED ( 'Table' ), [current_measure] )
)

Best Regards,

Jay