Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I am trying to build a calculated column in DAX that will display the correct total not only as the result of the sum of the column, but also as the result of each of the rows. As in the following picture:
1.Without filters
2.The result should be dynamic based on filters applied from the filter object visual and the result is still correct:
So far I have built the following code but without the expected result:
Total ACT Vol-Column = CALCULATE(
SUM(Worksheet[ACT Volume]),
ALLSELECTED(Worksheet)
)
The result that I am receiving is a static value, which does not change according to the applied filter and also the sum of the column gives me an incorrect value:
3.Without filters
4.with filters
How can i adjust my code so that my calculated column gets the expected result and behavior.
Solved! Go to Solution.
Hi,
Download the revised PBI file from here.
No. A calculated column formula does not recalculate on a change in slicer/filter. Why do you want a calculated column formula when in fact my measure gives you the right answer?
Hi,
Doesn't only this measure work
=SUM(Worksheet[ACT Volume])
If it does not hlp, then share the link from where i can download your PBI file.
Hello, thank you very much for your answer, I already tried it and it doesn't work, I leave you a link to download the pbix file:
Hi,
Download my PBI file from here.
Hope this helps.
hello, no, a measure does not work for me because I need the grand total to also be replicated row by row and change depending on the application of the filters, in its solution the result of each row is reflected according to its SKU, I want to reflect the sum of the total volume in each row.
Like in the image.
The total of each row also corresponds to the total value, and must recalculate its value according to the applied filters.
Without filters
with filters
Hi,
Download the revised PBI file from here.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |