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 ho...
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 )
)
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 )
)
Peter_2020's avatar
Peter_2020
Helper III
3 years ago

Hi Jihwan_Kim , thank you so much. it works.