Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table skills that has a column called CanonicalValue and it has two measures: SkillCount and X_PercentileValue
SkillCount = CALCULATE(COUNTAX(skills,skills[CanonicalValue]))
X_Percentile_Value =
VAR SummaryTable =
SUMMARIZE (
'skills',
skills[CanonicalValue],
"Count", [SkillCount]
)
RETURN
PERCENTILEX.INC(SummaryTable,[Count],Parameter[Parameter Value])
I want to create a third measure that evaluates whether X_Percentile_Value is greater than SkillCount.
This is my current visual layout.
The CanonicalValue column has duplicates and the SkillCount measure reflects the counts correctly.
Solved! Go to Solution.
Hi @daxBeanz ,
What do I need to do after the comparison? You can simply determine this with an if expression.
Greater = IF([X_Percentile_Value]>[SkillCount ],1,0)
Please feel free to correct me and provide more information if I have misunderstood you!
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @daxBeanz ,
What do I need to do after the comparison? You can simply determine this with an if expression.
Greater = IF([X_Percentile_Value]>[SkillCount ],1,0)
Please feel free to correct me and provide more information if I have misunderstood you!
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @daxBeanz
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
111 | |
104 | |
85 | |
65 | |
63 |