Dynamic legend with percentages only totalling for entire date period

[Clinical_Epi]

Hi all,

I am sucessfully running dynamic titles, and line filters etc, and am stretching the dashboard design to its breaking point (I feel). I'm hoping one of you may have encountere d- or can see the solution to this problem..

Using the below measure, which is part of an unpivoted table - linked via index to the fact table, but I cant work out how to make the percentage dynamic by date selection..

For example my measure: 

%ED  = DIVIDE([ED Value],CALCULATE([ED Value],ALLEXCEPT('_ED filter','_ED filter'[filter value])))

Using the "presentation date" from within the fact table is showing 100% over the whole date range... How can I make it dynamically show a different spread for the years - ie: for exmaple instead of the current way it works below

So if I filtered the date to start from 01 July 2021 I would get a 100% spread over that time frame... I would have thought if I expanded or minimsed the date range using a date slider it would be able to show the percentage change for that period... and not just stick to 100% over the whole underlying table... lets say a year goes by, the percentages for each year would be different...

Is there a way to make the percentage 100% for each year AND having it dynamic?

Many thanks and appreciate its a difficult one. 

Clin Epi

[Anonymous]

Hi @Clinical_Epi ,

It may be because in the ALLEXCEPT function, the field of the filter you want to keep is different from the field you actually filter. If possible, please provide some simple sample data and expected results, in tabular form.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.