Distinct Count depending of a measure

[Anonymous]

Hello, 

I created a 1st measure to have the product of two columns. and I'm trying to create a 2nd measure giving me all the values <50% and need to distinct count the 1st measure. 

Someone can help me with this?

Thank you

[ZunzunUOC]

Hi @Anonymous , could you share your RAW data to understanding better?

[Anonymous]

Thank you for you response. 

My data was organized as below: 

Code        |   Date           |           Measure Occupation Rate

901-321     29/04/2019                 50,0%

901-321     29/04/2019                 55,0%

901-321     29/04/2019                 72,0%

901-321     29/04/2019                 95,0%

I want to create a measure to calculate the number of times Measure Occupation Rate appears with 50,0% and count the number of lines that appears on the column of my table measure. 

Hope that you can help me with this. I think I am doing something wrong 😞

Thank you in advance 🙂 

[ZunzunUOC]

Hi @Anonymous , sorry, I was on holidays. Do yo still need help?

[Anonymous · Accepted solution]

Hello, 

@ZunzunUOC After a while I understood that for my data I needed an additional table for the measure don't duplicate values, so I did without calculating with measures 🙂

Thank you for you help