Forum Discussion

afrutos's avatar
afrutos
Resolver I
4 years ago
Solved

Return the most repeated value

Hello everyone, I have a question if you have any solution, thanks in advance. I have a tab created, getting detailed. In it, I am trying to put in a "multi-row card" display where it shows me the IdPeli that is most repeated in my matrix, I have tried it with mode but I can not do it.

 

So in my example I should get IdPeli= 546440 as the IdPeli most repeated in my matrix

 

Can anybody help me?

Thanks a lot 

 

 

  • afrutos's avatar
    afrutos
    4 years ago

    In the end the users changed their request and it is not necessary to bring up this case, if necessary, I will ask again and explain the cases well.
    Thank you anyway

3 Replies

  • With this formula I obtain the mode, but I would like it to taki into account the filters applied to that page, so that the mode would be 546440 

    Is there any way to calculate the mode or at least the IdPeli that, in my matrix, appear the most?

     

    Thanks

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi afrutos ,

    Have you resolved the issue now? Could you please provide the your pbix file without privacy information and desired output with more details?

     

    How to Get Your Question Answered Quickly 

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • afrutos's avatar
      afrutos
      Resolver I

      In the end the users changed their request and it is not necessary to bring up this case, if necessary, I will ask again and explain the cases well.
      Thank you anyway