Forum Discussion
Sum in PowerBI
Hi Audreys,
You can create a parameter table with the category type which you wanted, then use it as the axis of the chart and write a measure formula to calculate based on the current category type:
Regards,
Xiaoxin Sheng
Hi Audreys ,
Please share a sample data (that we can copy-paste/excel file) and your expected result?
Dear,
thanks for your asnwer.
Indeed i have 2 problems:
- i need to have the total of "nombre de current registration status AND total of "premier maximum enrollment". Those datas are coming from a query (it's not a table I created myself as it is dynamic) and I am putting the view as a table to have the details.
- The second problem, is, as soon as I have the total of the 2 collumns, I would need that the principal graph shows me the difference between the number of participants that already registered and the total of the maxium of people that can be registered. See the visual made in PPT
Here are an exemple of the table I have :
| Title | Current registration | Maximum Enrollments |
| Global boot camp digital | 24 | |
| MC Bakery regional | 7 | 18 |
| Global bootcamp hands-on | 5 | 10 |
| MC Chocolate | 3 | 9 |
| MC Patisserie regional hands-on yellow belt | 2 | 9 |
| MC patisserie regional hands-on long shelflife | 1 | 10 |
Hi Audreys,
You can create a parameter table with the category type which you wanted, then use it as the axis of the chart and write a measure formula to calculate based on the current category type:
Regards,
Xiaoxin Sheng