I am having problems with a dax formula. I need to calculate the addition of the max% (yellow column). These values belongs to a table where i have a set of criteria (1,2,3…9) different per year and this needs to be applied to each group. So for the year 2017 I have 1,2,3,4,8,9, for the year 2018 1,2,3,4,5,6,8,9 and for the year 2019 1,2,3,4,5,6,7,8,9.
The formula that i am using and its not working is because i am getting the sum for all ids without taking into account the year:
Max % = CALCULATE ( SUM ( 'dwh group'[max_Value_] ); ( 'Calendar'[Year] ); 'dwh group'[Calculation] = "Yes"; 'rpt v_group'[group_id] )
An additional question, if i have a report level filter (calculation=“yes”), do i need to use it still in the dax formula for a measure?
Thanks very much in advance!!