Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
HELP PLEASE, Can anyone assist with debugging this measure, from the 2 columns of the table, I want to distinctcount the datetime column, unless the associated count column value is less than 10?? TIA Daniel
Solved! Go to Solution.
This looks like a couple of syntax errors. You need a close parenthesis for DISTINCTCOUNT and another for CALCULATE. Also, there should not be a space between > and =.
Try this:
15m count NEW =
CALCULATE (
DISTINCTCOUNT ( 'Larapinta Stats (2)'[datetime] ),
FILTER ( 'Larapinta Stats (2)', 'Larapinta Stats (2)'[Count] >= 10 )
)
This looks like a couple of syntax errors. You need a close parenthesis for DISTINCTCOUNT and another for CALCULATE. Also, there should not be a space between > and =.
Try this:
15m count NEW =
CALCULATE (
DISTINCTCOUNT ( 'Larapinta Stats (2)'[datetime] ),
FILTER ( 'Larapinta Stats (2)', 'Larapinta Stats (2)'[Count] >= 10 )
)
Excellent thankyou!
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |