Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
92 | |
82 | |
70 | |
64 |
User | Count |
---|---|
115 | |
106 | |
96 | |
81 | |
72 |