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 moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hi,
I am trying to get the next bottom ranked value that is not zero. This is what I currently have written to return the first ranked lowest value.
Is there a way to write something that says
IF result = 0 then
Maybe this to return positives only into the measure :
Least COUNT =
VAR _rank = CALCULATE(
Audit[Sum Audits and Entries],
FILTER(
System_Users,
RANKX(
System_Users,
Audit[Sum Audits and Entries],,
ASC,
DENSE
) = 1
)
) + 0
VAR Result = If ( _rank > 0 , _rank )
Return
Result
Good luck !
Great thought. Unfortunately it just removes the results with zero.
Visualization Filters
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
21 | |
21 | |
21 | |
13 | |
12 |
User | Count |
---|---|
43 | |
28 | |
25 | |
23 | |
22 |