Forum Discussion

Tito's avatar
Tito
Icon for Helper IV rankHelper IV
4 years ago
Solved

Rankx with Allselected

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. ...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    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's avatar
Tito
Icon for Helper IV rankHelper IV
4 years ago

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

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Tito
      Icon for Helper IV rankHelper IV
      4 years ago

      Hi Jihwan_kim

      Thank you for your help 👍