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.
I am attempting to create a dynamic rank to rank all filtered name/accounts (Athlete[Name] by total engagments (Sum of likes and shares columns), but the data isn't filtering out even though I'm using ALLSELECTED. For this example, I've filtered by NHL teams but the graph is still acting like all name/accounts in the database are selected, even though the dynamic rank seems to be working for the filtered names. I've attached the formula I attempted to use and how my relationships are managed. Thanks!
HI @AW31,
According to your description, it sounds like you are trying to create a dynamic calculated column to calculate rank based on filter and slicers, right? If this is a case, current power bi does not support to create dynamic calculate column/table based on filter/slicer.
In fact, they are work on different data levels, filter and slicer work on data view level which generated from the data model. Power bi does not support using 'sub-level' to effect its 'parent level'. (Actually, when you enable filter/slicer, you can find they can't affect data model table records)
Regards,
Xiaoxin Sheng
I see I used filter as the wording, but I think I'm just using slicers? When I use a slicer for NHL teams without the rank column created, it only shows the data for those accounts. When I add in the rank column, it populates all accounts even though only the NHL teams is selected on the slicer. So it may not be possible.
Hi @AW31 ,
Dynamic columns based on selection is impossible, but you can write measure to instead. It will be affected by filters and dynamic change calculation result based on its row contents.
Regards,
Xiaoxin Sheng
The formula I used was
HI @AW31 ,
Maybe you can try to add an if statement to filter records who have rank larger than 30.
Rank = VAR _rank = RANKX ( ALLSELECTED ( Athlete[Name] ), CALCULATE ( [Engagements] ) ) RETURN IF ( _rank <= 30, _rank )
Regards,
Xiaoxin Sheng
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |