How to multiply same column qty

[rainchong7401]

Hi Friends,
I'm very new to Power BI.
I hope someone can help me out here.

Section A I can achieve what I want.
But when comes to Section B.
Second part, It's not what I want and I've no idea how to do it.
"When I've done Remaining Qty at the same day with more than 2 lines,
It will highlight the Remaining Qty >0 for me" not correct.

Expected output: Section B second part,
I want it to multiply itself when there's a same date of remaining qty.
If multiply result = 0 no need highlight if multiply result >0 highlight.

[v-yadongf-msft]

Hi @rainchong7401 ,

Please try following DAX:

Count = CALCULATE(COUNT('Table'[Date]),FILTER('Table','Table'[Date] = EARLIER('Table'[Date])))

Measure = IF(MAX('Table'[Remaining]) <> 0 && MAX('Table'[Count]) <> 1, "SKYBLUE")

Apply conditional formatting for every field:

Best regards,

Yadong Fang

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

[rainchong7401]

Hi Ya Dong,
I think I had confused and miscommunicated with experts here.
This is the output I got.
My current output for myself is 1,2,3,4 
But:

My expected output is Number 1,2,3,5 No 4 Included:
If I can finish receiving goods in a day then don't highlight anything. 
Since at the same day you can find 0 qty which mean I already done receiving. 
The problem is how to get rid of number 4 and replace number 5 logic.
I want to have something like 1,2,3,5