Get Percentage by Total Amount but using the filter of Date.

[kdixon5490]

Measure Help please

I have a table with the following fields

From those fields I need to get the percentage total for that Quantity Sold is over 2019 Attendance.

So if the user select 2021-05-17 -  2021-05-20  I would need the sum of the quantitySold and the sum of the 2019 Atteandance and then do a percentage on that.

[V-pazhen-msft]

@kdixon5490 

@TomMartens 's measure should work, use either slicer or filter panel will automatically change the measure. Please take a try.

measure =

divide(

calculate(sum('Table'[Quantity Sold]))

, calculate(sum('Table'[2019 Attendance]))

)

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[kdixon5490]

This did not work I'm using the filter panel to select dates.

[TomMartens · Accepted solution]

Hey @kdixon5490 ,

assuming that the user selects the dates using a date slicer, create this measure:

measure=
divide(
calculate(sum('thetablename'[Quantity Sold]))
, calculate(sum('thetablename'[2019 Attendance]))
)

If this does not provide what you are looking for, create a pbix file that contains sample data, but still reflects your data model. Upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data, share the Excel file as well.

Regards,
Tom