Mystery formula to add the result of the columns by line

[Anonymous]

Good morning all,

New user of Power BI, I try to train myself to use it through a fun dashboard.

So I loaded the database of French games and I try to bring out the numbers of the Euromillion that come out the most to have a little fun and a nice database.

In short, this complicates in my table indeed I cannot identify the adequate formula to add all of my columns by line nor use the TOPN function to get my top 5 numbers

If someone can help me this will allow me to progress in the operation of the tool.

here is the link of my PBIX:

https://www.transfernow.net/x2xqBA052020

Thank you

-Bonjour à tous,

Nouvel utilisateur de Power BI, j'essaye de m’entraîner à l'utiliser aux travers d'un dashboard ludique.

J'ai donc chargé la base de donnée de la française des jeux et j'essaye de faire ressortir les numéros de l'euromillion qui sortent le plus pour avoir un peu de fun et une belle base de donnée.

Bref cela ce complique dans mon tableau en effet je n'arrive pas à identifier la formule adéquate pour additionner l'ensemble de mes colonnes par ligne ni à utiliser la fonction TOPN afin de sortir mon top 5 des numéros

Si quelqu'un peu m'aider cela me permettrai d'avancer dans le fonctionnement de l'outil.

voici le lien de mon PBIX :

https://www.transfernow.net/x2xqBA052020

Merci

[dax]

Hi @Anonymous , 

I am not clear about your requirement, did you want to rank your count columns, right? If so, you could try to create below measures , then filter it(you need to creat rank value for each columns, if you want to rank them)

rank1 = RANKX(ALLSELECTED('Numeros officiels'),CALCULATE( COUNT('Boule 1'[boule_1])),,DESC,Dense)

 You could refer to my sample for details.

Best Regards,
Zoe Zhi

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

[Anonymous]

Hello Zoe Zhi,
I'm looking for a formula allowing me to count the sum of line 33 in my example. namely: 13 + 20 +31 +26 +15 is to indicate the result on the right in a new column.

[dax · Accepted solution]

Hi @Anonymous , 

If you want to get sum of columns, you could try below measure

Measure = CALCULATE(COUNT('Boule 1'[boule_1]))+CALCULATE(COUNT('Boule 2'[boule_2]))+CALCULATE(COUNT('Boule 3'[boule_3]))+CALCULATE(COUNT('Boule 4'[boule_4]))+CALCULATE(COUNT('Boule 5'[boule_5]))

Best Regards,
Zoe Zhi

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