Return the most repeated value

[afrutos]

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 

[v-rongtiep-msft]

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 · Accepted solution]

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

[afrutos]

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