Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |