Forum Discussion

Peter_2020's avatar
Peter_2020
Helper III
3 years ago
Solved

Count

rHi all, 

I would like to ask for help with following situation:

I have table with Product Number filtered by the project. And for all products I created:

 - measure "Questions" which calculate how many questions in checklist are related to that product,

 - measure "OK" which calculate how many questions from the checklist was ok and

 - measure "Result" which calculate how many % of the question was ok. 

And I need to calculate how many products had result 100% for selected project (on the picture below it is measure "100% at first time"). Always when I used some of the Count commands I received wrong numbers...

Any idea how to do this?

Thanks.

P.

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I am not sure how the Data model looks like, but please try writing a measure something like below.

     

    expected result measure: =
COUNTROWS (
    FILTER ( DISTINCT ( 'TableName'[PRODUCT NUMBER] ), [RESULT Measure] = 1 )
)

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    Hi,

    I am not sure how the Data model looks like, but please try writing a measure something like below.

     

    expected result measure: =
COUNTROWS (
    FILTER ( DISTINCT ( 'TableName'[PRODUCT NUMBER] ), [RESULT Measure] = 1 )
)