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,
I'm very new about Power BI and so far I didn't find difficult, but now I have a issue about the sum.
My goal is to sum a specific row in a matrix.
Is it possible?
I know that is possible to create a cumulative sum, but I don't need of it. I need just of one value as in the example.
Below a simple example.
Thank you in advance
Solved! Go to Solution.
Hi @Anonymous ,
I create a calculated column. The formula is as follows:
goal =
IF(
'Table'[X] = "25-30",
CALCULATE(
SUM('Table'[Z]),
FILTER(
'Table',
'Table'[Index] <= EARLIER('Table'[Index])
)
)
)
The result is as follows, is this the output you want?
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
I create a calculated column. The formula is as follows:
goal =
IF(
'Table'[X] = "25-30",
CALCULATE(
SUM('Table'[Z]),
FILTER(
'Table',
'Table'[Index] <= EARLIER('Table'[Index])
)
)
)
The result is as follows, is this the output you want?
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
I do not know well about your case, but by only seeing the screen capture, if you specify which category to show the result & other categories to hide, it is possible to demonstrate it.
(for instance, only show 25-30 category)
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: https://www.linkedin.com/in/jihwankim1975/
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.
Thanks @Jihwan_Kim for you reply.
I understand the point, but how can select the filter that you mentioned?
Hi,
You mean, how to select a specific category by slicer?
If you create a slicer from the existing table, and if you select a category, then the visualization would only show the selected category. I think this is what you want to ask.
In this case, the model needs to have a separate table (one column table) that only operates the slicer.
Then, this will only correspond to the measure based on the selection.
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.
Thank you for the answer, but I'd like to create a column in the matrix that it is able to calculate the subtotal of a specific range.
I need of this value becuase I have to implent it in a chart like threshold.
Hi,
Thank you for your feedback.
I am not sure about your specific case and a model, but in a general situation, it still can act as a threshold value even it is created as a measure.
If it is created as a calculated column, there will be some limitation, for instance, non-dynamic...
Thanks.
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |