Dax calculation not working with Filter or Row data.

Question

I'm rather new to Power BI so please be patient with this question.&nbsp;I have a data table that has the followoing columns.Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Date&gt;,Dynamic&nbsp; &nbsp; &nbsp; &nbsp;&lt;Int&gt;,Sold&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;float&gt;,Attendance &lt;float&gt;,Percentage&nbsp; &nbsp;&lt;float&gt;&nbsp;With data that looks likeDate&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Dynamic&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sold&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Attendance&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Percentage12/05/2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 399&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 808&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 49.3812/05/2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;146&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 267&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 54.68Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;545&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1075&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;104.06&nbsp;I want the total percentage to always be 100% but I'm not sure what I'm doing incorrectly.&nbsp;I did this calculation inside of SQL before pulling the data but I understand that may not be the best way.&nbsp;Because I currently have 2 slicers on the page 1 for Date and 1 for Dynamic pricing .&nbsp;Any help would be appreciated.&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;

amitchandak · Accepted Answer

kdixon5490 , if you need % of total of sold a new measure = Divide(Sum(Table[Sold]), calculate(sum(Table[Sold]), allselected()) ) 
&nbsp;
or % of total attendance
&nbsp;
Divide(Sum(Table[attendance]), calculate(sum(Table[attendance]), allselected()) )
&nbsp;
Power BI Percent of Total and Percent of SubTotal: https://www.youtube.com/watch?v=cN8AO3_vmlY&amp;t=24270s
&nbsp;
&nbsp;

Forum Discussion

Dax calculation not working with Filter or Row data.

1 Reply

Related content

Calculating with Filters

Calculate Filters

Filters not working properly

Filter not working in calculate

Calculation not working when slicers applied