Quotient Remainder is not Displaying Correct Data

[Stuznet]

Hi all,

I have yet to find a solution to this problem. Everything calculated correctly except when I filter On Time to Yes or No, I'm not getting the result I want to see in the Data

This is the percentage measure I created

Percentage = 
VAR AA = COUNT(Data[ID])
VAR BB = CALCULATE(COUNT(Data[ID]),FILTER(Data,Data[On Time] = "Yes"))
RETURN
DIVIDE(BB,AA,BLANK())

And this is the Remainder measure

Remainder = 
VAR AA = COUNT(Data[ID])
VAR BB = CALCULATE(COUNT(Data[ID]),FILTER(Data,Data[On Time] = "Yes"))
RETURN
1-DIVIDE(BB,AA,BLANK())

Theoretically, when I click on December 75% and the remainder is 25% I expect to see 25% that is Not On Time and not 300% and blank

 

Can someone please kindly help me?

Here is my a dummy data.

Data.pbix

Thank you

[v-frfei-msft]

Hi @Stuznet,

As you picture you shared, if you choose the On option in the slicer. Then the table will be filterd, so the result will be impacted at the same time. If you use ALL function to ignore the filter, the result will be not the the ones as you excepted as you wished in the table visual. One more question, you add one filter in your formulas that make the On Time is equal "Yes", why did you want to choose No in the slicer?

Regards,

Frank

[Stuznet]

I just didn’t know how to explain better but I found the solution
https://forum.enterprisedna.co/t/percentage-not-calculating-correctly-based-on-selection-context-in-...