Help with equal values

[deniselias]

Hello guys,

I need help with a situation:

A table with a currency data source contains 11 rows but I cannot remove duplicates, my need is to take the first row only because the expression is adding up all 11 rows.

I using the following expression and this is my currency data: (I can't leave a line just)

And this is the calculation displayed:

Could I somehow use ALLEXCEPT or DISTINCT or DISTINCTCOUNT or COUNTROWS?

Thanks

@v-yiruan-msft 

[Jihwan_Kim · Accepted solution]

Hi, @deniselias 

I am not sure how you wrote your current measure, but please try writing something like below.

New measure =
SUMX (
VALUES ( [the column that you are using in your current measure] ),
[your current measure]
)

Or, please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate measure.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM