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.
Hi guys.
I am trying to get a Count over a measure with specific conditions, like value between 20 and 25% and value over 25%.
I honestly have no clue on how to do it. I built this table to picture what I am looking for, I think it's clearer this way:
Any ideas?
I don't need all the code, maybe with a few hints I can do it.
Thanks in advance!
Solved! Go to Solution.
Hi @Anonymous,
Based on the PBIX file you shared I believe that the issue is based on context because in the measure you created you are making based on Name and Date but on the count of the percentages you are not giving that same context so the result is not correct.
Create a column based on the date from your table:
MONTH = FORMAT(TABLE[DATE];"mm-yyyy")
Then create the following measure:
COUNT % 20 - 25 = COUNTROWS ( FILTER ( SUMMARIZE ( ALL ( TABLE[NAME]; TABLE[MONTH] ); TABLE[NAME]; TABLE[MONTH]; "% Count"; [MEASURE TO BE COUNTED] ); [MEASURE TO BE COUNTED] >= 0,2 && [MEASURE TO BE COUNTED] <= 0,25 ) )
Believe this should work, but check the PBIX file I have return to you trough private message.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |