Rankx with Allselected

[Tito]

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

[Tito]

Hi Jihwan_kim
The problem has (currently) been resolved.

Thank you very much

[Tito]

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

[Jihwan_Kim · Accepted solution]

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. 

[Tito]

Hi Jihwan_kim

Thank you for your help 👍

[Jihwan_Kim]

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"
    )

[Tito]

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

[Jihwan_Kim]

Hi,

Thank you for your message.

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