Percentage Help

[mahitham]

Hi Experts,

Can any one please help me on below issue. I have 5% in Measure 1 for the month of Jul-2018.

But when I filter Month=Jul-2018 then this 5% turns to 100%.

I have used the below expression. Please help me on this.

Sum(if([ Not Null <3days]='True' or [Null <3days]='True',[Count]))
/
Sum(Total if([ Not Null <3days]='True' or [ Null <3days]='True',[Count]))

Thanks in advance

[PrashantSangle]

because when you select Jul-2018 then you denominator change
In denominator used set analysis

Sum({1<[ Not Null <3days]={'True'}>+1<[ Null <3days]={'True'}>}Count)

[jonathandienst · Accepted solution]

Override the Month selection in the divisor:

Sum(if([ Not Null <3days]='True' or [Null <3days]='True',[Count]))
/
Sum({<Month>} Total if([ Not Null <3days]='True' or [ Null <3days]='True',[Count]))