Sum Cards with dynamic value

Question

We are trying to sum up different cards with dynamic values and cannot figure out how to do so. We are wanting to be able to select different percentages for each category and it sum the totals on the left. Is there a way to do this without coding? Thanks for any help!

mfelix · Answer

Hi ktaylorBHS,If I understand correctly you want to select the percentages in the right and add those values to.the cards on the left, so if you have the 1st number 5.73k and select 50% you want to have 5.73k +( 5.73k*0.50).You need to make somethong.like this:Measure = Measure *1+min(table[percentage])Regard,MFelox

ktaylorbhs · Answer

I am wanting to add all the cards on the left. For example, I could select 30% on the first card, 20% on the second, etc and then be able to sum them all up and the number be dynamic that way if I wanted to change the percentage on the first one, it would change the total. Does that make sense? Not sure if that is even a possibility. Thank you for the help!&nbsp;

mfelix · Answer

How are you getting the values on the cards? Is it a measure or do calculate it directly from a column in your data?&nbsp;Mfelix

ktaylorbhs · Answer

It is from a column on an Excel spreadsheet.&nbsp;

v-huizhn-msft · Answer

Hi&nbsp;ktaylorBHS,Whta's the visual you used?&nbsp;&gt;&gt;For example, I could select 30% on the first card, 20% on the second, etc and then be able to sum them all up and the number be dynamic that way if I wanted to change the percentage on the first one, it would change the total.If we create slicer visual, we can filter the table by clicking special value on it. For your requirement, how to select the 30% on the first, 20% on the second? Do you mind share your .pbix file for further analysis?Thanks,Angelia

Forum Discussion

Sum Cards with dynamic value

9 Replies

Related content

Dynamic Cards by Selection on a Chart

MULTIPLE CARD

Dynamically change text box or card value

Dynamic text box and Card?

Ranking KPI card