Forum Discussion

rainchong7401's avatar
rainchong7401
Helper III
3 years ago

How to multiply same column qty

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.

Need Help

2 Replies

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Community Support
    3 years ago

    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's avatar
      rainchong7401
      Helper III
      3 years ago

      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