Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
Hi @Anonymous , could you share your RAW data to understanding better?
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 🙂
Hi @Anonymous , sorry, I was on holidays. Do yo still need help?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |