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 Experts,
I have a table with some years and some value. I want to have the sum of all the value on each rows but using a column instead of a measure. If I use the following same formula on the column and on the masure I don't get the same result when I change the data filter. How do I have to change the formula in order to have the same result I have in the measure?
THis is the formula I used on both column and measure
Solved! Go to Solution.
@Guitarseb , the Column is a calculated column, isn't it? A calculated column is irrelevant to any slicers whereas a measure is so.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
@Guitarseb in calculated column, the calculation can not get the value in any slicer.
@Guitarseb , the Column is a calculated column, isn't it? A calculated column is irrelevant to any slicers whereas a measure is so.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Yes it is. Indeed you are right so it is not possible...
Try:
CALCULATE(sum(Tabella[value]),ALL(Tabella))
Thanks for your reply
WIth ALL the column has the same behaviour. If i use it on the measure it works like the column giving always the value 3803 even if I change the year filter and this is not what I want
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 |
---|---|
41 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |