Forum Discussion
Sum in PowerBI
Dear,
I would like to have the total of "premier maximum enrollments" to be able next to see in the graphic the difference between "nombre de current registration status" and "premier maximum enrollments".
Can someone help me on this please? I am a bit blocked as I already tried different things... 😞
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
3 Replies
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
