Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi I'm tring to write a measure that will count the row is
if a certain criteria is less than 70% I came up with the below but it is showing a weird number and there is currently only 14 rows.
Solved! Go to Solution.
Thank you, I found the problem, I had the wrong table in the first portion of the measure.
@Anonymous ,
Please try this:
<70% = CALCULATE( COUNTROWS( SQL ),
FILTER(SQL,SQL[AA Utilisation MTD]<.7))
If this doesn't work, please post your table as text so it can be easily copied.
Regards,
Thank you, I found the problem, I had the wrong table in the first portion of the measure.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
107 | |
68 | |
48 | |
47 | |
44 |