Sum in PowerBI

[Audreys]

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... 😞

[danextian]

Hi @Audreys ,

Please share a sample data (that we can copy-paste/excel file) and your expected result? 

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/2564882#M9069... 

[Audreys]

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

[Anonymous · Accepted solution]

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:

My Favorite DAX Feature: SELECTEDVALUE with SWITCH | Winston-Salem Power BI User Group (pbiusergroup...

Regards,

Xiaoxin Sheng