Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
88 | |
82 | |
64 | |
49 |
User | Count |
---|---|
125 | |
111 | |
88 | |
69 | |
66 |