Forum Discussion
Sum selected % from table into card
Hi,
How do I select the 3 column highlighted in red (let's say the legend is : A,B,C,D,E,F,G,H) and sum up the percentage (legend : D,F,G) into a card?
And this will change according to selection from another filter.
Thank you in advance
Hi ngiam ,
According to the information you currently provide, if you want to select the marked column as a specific color, you can directly change it in the data colour in the format.
Since I don’t know the specific judgment logic of the field in your visual, is it a field in the original data model or a created measure? No further tests can be done temporarily.
Or you can use the method of condition judgment to change the specific column that meets the condition, refer to the following.
If you require the sum of the selected per value, you can try to create a measure, using the If function, set the per value that meets the condition to 1, otherwise it is 0. Finally, sum the per value corresponding to value 1.
If the problem is still not resolved, please provide a detailed data model and information, so as to facilitate my further testing. Let me know immediately, looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
ngiam really not sure what you are looking for, share sample data and expected output. Is this % a measure? Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Hi ngiam ,
According to the information you currently provide, if you want to select the marked column as a specific color, you can directly change it in the data colour in the format.
Since I don’t know the specific judgment logic of the field in your visual, is it a field in the original data model or a created measure? No further tests can be done temporarily.
Or you can use the method of condition judgment to change the specific column that meets the condition, refer to the following.
If you require the sum of the selected per value, you can try to create a measure, using the If function, set the per value that meets the condition to 1, otherwise it is 0. Finally, sum the per value corresponding to value 1.
If the problem is still not resolved, please provide a detailed data model and information, so as to facilitate my further testing. Let me know immediately, looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
