Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a Table visual that displays a code and its associated description. I am able to rank the code according to its frequency using the following DAX expression:
[Selected Tariff View] = COUNT('Claims Fact'[Tariff Code ID])
Rank Tariff by Selected View = IF(
HASONEVALUE('Tariff Dimension'[Tariff Code]);
RANKX(
ALLSELECTED('Tariff Dimension'[Tariff Code]);
[Selected Tariff View]
)
)
Here is the result:
I now add the associated description to the Table visual. But when I do, I loose the rank. Here is what happens:
What am I doing wrong?
Thanks..
Solved! Go to Solution.
Hi @Anonymous
Add Tarriff Description as a parameter
Rank Tariff by Selected View = IF ( HASONEVALUE ( 'Tariff Dimension'[Tariff Code] ), RANKX ( ALL ( 'Tariff Dimension'[Tariff Code], 'Tariff Dimension'[Tariff Description] ), [Selected Tariff View] ) )
Hi,
Also, you may want to explore the LOOKUPVALUE() function to bring over the description field into your Table.
Hi @Anonymous
Add Tarriff Description as a parameter
Rank Tariff by Selected View = IF ( HASONEVALUE ( 'Tariff Dimension'[Tariff Code] ), RANKX ( ALL ( 'Tariff Dimension'[Tariff Code], 'Tariff Dimension'[Tariff Description] ), [Selected Tariff View] ) )
Hi @Zubair_Muhammad,
I see you have used 'ALL' which gives you the option of adding another parameter instead of 'ALLSELECTED', which is what I am using but doesnt give the option of additional parameters.
I am using 'ALLSELECTED' as I want to maintain the filter context of any filters already selected. Is there any way to do what you have suggested but with keeping the Filter context of any filters already selected?
Thanks
HI @Anonymous
Interesting...
Could you show how it impacts your results?.....The incorrect result and result you expect
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |