Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |