topic Rankx with Allselected in DAX Commands and Tips

Rankx with Allselected

Tito — Mon, 11 Jul 2022 08:52:01 GMT

Hello everyone,
how can i get the number 3 in the map, if i select line 3 in the table.

I have to use the ALLSELECTED (not All) function here because I want more selections in the filter.

Thanks

Re: Rankx with Allselected

Jihwan_Kim — Mon, 11 Jul 2022 09:19:48 GMT

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below, and I hope the below can provide you the way to find the solution for your data model.

Ranking measure: = VAR _newtable = FILTER ( ALL ( Data ), [Wenn Gesamt:] <> BLANK () ) RETURN IF ( HASONEVALUE ( Data[Versicherer] ), IF ( NOT ISBLANK ( [Wenn Gesamt:] ), RANKX ( _newtable, [Wenn Gesamt:],, ASC, DENSE ) ), "Selecte one of lines from the table visualization" )

Re: Rankx with Allselected

Tito — Mon, 11 Jul 2022 10:15:24 GMT

Thank you very much.
doesn't have to be a relationship between " Slicer table" and "Data" ?

Re: Rankx with Allselected

Jihwan_Kim — Mon, 11 Jul 2022 11:14:43 GMT

Hi,

Thank you for your message.

If the relationship is there, the measure has to be written in a slightly different way.

Re: Rankx with Allselected

Tito — Mon, 11 Jul 2022 11:42:12 GMT

Hi,
Thank you for your message.
the relationship must exist in my data model.
What should I change now in Measure, please?

Re: Rankx with Allselected

Jihwan_Kim — Mon, 11 Jul 2022 12:11:09 GMT

Hi,

Sorry that I could not find a way to fix the measure when having No-disconnected table for the slicer purpose.

Please check the below picture and the attached pbix file.

For now, I suggest having a dimension table and a slicer table like below. The dimension table still filters and has relationship with a fact table. And at the same time, there is one disconnected table that acts as a slicer on the report.

Re: Rankx with Allselected

Tito — Tue, 12 Jul 2022 10:42:04 GMT

Hi Jihwan_kim
The problem has (currently) been resolved.

Thank you very much

Re: Rankx with Allselected

Tito — Mon, 25 Jul 2022 07:30:33 GMT

Hi Jihwan_kim

Thank you for your help 👍