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.
Hey everyone,
I have a top 10 rank matrix for a few different categories on a dataset.
For some reason, when I try to use a filter slicer to show different results it starts duplicating ranks or skipping numbers out.
RankSpecialism = IF(
NOT(
ISBLANK([total GP])),
RANKX(
Filter(
ALLSELECTED('All Companies'[Specialism]),[Total GP]),
[Total GP],,
DESC
,Dense))
I have tried changing the ALL to ALLSELECTED and a few different versions. does anyone have any advice on what I could try to get this working correctly even if I filter using a filter slicer?
Thanks in advance!
@EitanKGCS
Please try the following :
RankSpecialism =
IF (
NOT ( ISBLANK ( [total GP] ) ),
RANKX ( ALLSELECTED ( 'All Companies'[Specialism] ), [Total GP],, DESC, DENSE )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Still no luck!
Still getting this result when filtering using a slicer.
@EitanKGCS
Please share your [Total GP] Measure.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Total GP = SUMX('All Companies',[@Profit])
User | Count |
---|---|
94 | |
79 | |
73 | |
63 | |
59 |
User | Count |
---|---|
110 | |
101 | |
84 | |
64 | |
62 |