Forum Discussion

rainchong7401's avatar
rainchong7401
Icon for Helper III rankHelper III
4 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 ...
Need Help
v-yadongf-msft's avatar
v-yadongf-msft
Icon for Community Support rankCommunity Support
4 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
    Icon for Helper III rankHelper III
    4 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