Forum Discussion

snandy2011's avatar
snandy2011
Icon for Helper IV rankHelper IV
7 years ago
Solved

Getting Problem on extracting a particular column's value by Dax

Hi Experts,   Please have a look on below scenario,   I have a Top ranking slicer (say value like,Top 5,TOp 10,TOP 15 etc).Based on this slicer i can simply calculate top customer 's deposit.(let...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    snandy2011 If you are looking to rank the data dynamically based on the Deposit Amount.... display based on the slicer selection (rank). Please try this... Add a new column as below:

     

    RnkDeposit = RANK.EQ(CustomerRank[DepositAmt],CustomerRank[DepositAmt])

    Then use this field as a slicer control then you can have data displayed as you like on whatever rank you want to see... 

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

snandy2011 If you are looking to rank the data dynamically based on the Deposit Amount.... display based on the slicer selection (rank). Please try this... Add a new column as below:

 

RnkDeposit = RANK.EQ(CustomerRank[DepositAmt],CustomerRank[DepositAmt])

Then use this field as a slicer control then you can have data displayed as you like on whatever rank you want to see... 

snandy2011's avatar
snandy2011
Icon for Helper IV rankHelper IV
7 years ago

PattemManohar

 

Thanks for reply..

 

Sure i will try and let you know the feedback..

 

Thanks,

snandy

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi snandy2011,

     

    Have you solved your problem?

     

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    If you still need help, please feel free to ask.

     

    Best  Regards,

    Cherry

    • snandy2011's avatar
      snandy2011
      Icon for Helper IV rankHelper IV
      7 years ago

      Hi v-piga-msft,

       

      Sorry for delaying..I was out of connection. I had solved this problem by myself before getting response from others. I accepted my answer as solution also.But, unfortunately,it got deleted.Although, PattemManohar's solution has also worked.So, i am accepting  his answer as my solution.

       

      Thanks for reminding me..

       

      Thanks,

      snandy