Measure to calculate % for a selected slicer

[enzo2011]

Hi everyone!

So my question is about how to create a measure that calculates the percentage of revenue respect the total revenue of the year selected. Here is an example of the data:

OK so I have 4 different slicers. One for each category and year. So what I want to show is the % of the revenue respect the year/years selected in the revenue. For example: if I filter for 2018, the total is €105. So if afterwards I filter by category I want to see the % of the categories I selected respect the total of 2018. 

The result will be to show a card with the percentage of 2018 (if I select 2018 in the slicer):

100% if only 2018 is selected

57.14% if 2018 and A7 is selected

100% if 2017 and 2018 is selected

27.27% if 2017/2018/B4 is selected

And so on...

The objective it to show the % of the revenue respect the year/s selected.

Sorry if I didn't explain myself very well...

If you have any doubt with the context I'll be very pleased to help you.

Thank you so much in advance!

Enzo

[Greg_Deckler · Accepted solution]

You want to use CALCULATETABLE. CALCULATETABLE allows you to feed it filters and only those filters are modified from the original context. You can see how this works in my Time Intelligence The Hard Way Quick Measure here:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[enzo2011]

Thank you so much Greg!

Your post was very helpful. Finally, I solved my problem.

Best regards,

Enzo