Dax calculation not working with Filter or Row data.

[kdixon5490]

I'm rather new to Power BI so please be patient with this question.

I have a data table that has the followoing columns.

Date            <Date>,

Dynamic       <Int>,

Sold            <float>,

Attendance <float>,

Percentage   <float>

With data that looks like

Date               Dynamic                        Sold                      Attendance            Percentage

12/05/2023          1                              399                            808                          49.38

12/05/2023           0                             146                            267                          54.68

Total                                                     545                           1075                         104.06

I want the total percentage to always be 100% but I'm not sure what I'm doing incorrectly.

I did this calculation inside of SQL before pulling the data but I understand that may not be the best way.

Because I currently have 2 slicers on the page 1 for Date and 1 for Dynamic pricing .

Any help would be appreciated.

[amitchandak · Accepted solution]

@kdixon5490 , if you need % of total of sold
a new measure =
Divide(Sum(Table[Sold]), calculate(sum(Table[Sold]), allselected()) )

or % of total attendance

Divide(Sum(Table[attendance]), calculate(sum(Table[attendance]), allselected()) )

Power BI Percent of Total and Percent of SubTotal: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s