Forum Discussion

baneworth's avatar
baneworth
Helper III
5 years ago
Solved

Count and Date Problems for Desktop (specific issue)

Hello All,   I don't have to use PowerBI that often so see me as an beginner. I will try my best to describe this issue as clear as i can.   Products go from "Build" to "Test" to "Prep" to "Comp...
Need Help
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi baneworth ,

     

    Because you are missing right parentheses after "Filter" function.

    Try below measure :

    measure = 
var _index=CALCULATE(MAX('pdlTest'[Index]),FILTER(ALL('pdlTest'),'pdlTest'[CompleteFlag1]=1&&'pdlTest'[CompleteFlag2]=1))
Return
CALCULATE(COUNTROWS('pdlTest'),FILTER(ALL(pdlTest),'pdlTest'[CompleteFlag1]=1&&'pdlTest'[CompleteFlag2]=0&&'pdlTest'[Index]<_index))

    Then you will see:

     

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

baneworth's avatar
baneworth
Helper III
5 years ago

Dear Denis,

 

Thank you for quick reply and i followed your input.

It is a hard for me to tell you that your recommended solution for count works since i got a problem i guess.

 

First, i added the dimension table (kept it simple for testing), but it seems there is nothing appropriate to link it to my dataset.

 

 

I tried linking it to "CompleteTime1" since this is also where CompleteFlag1 is related to.

But then it only counts the Flag1 & Flag2 condition the time it actually got entered by Technicians and not the other days following until Flag2 also switched from "0" -> "1".

 

isn't this the big problem here? not being able to link the data table accoridngly to my set?

- i tested with table to see daily count of the products, but they get counted one time only (Completetime1 date)

 

Best regards

Mat