Hello, i need help. I want this (blue)

[RPNancy54]

Hello,

I need help please. I don't speak very good english (i'm French).

I have BLUE answer with DAX.

Thank you so much

[apaulso9]

Hello,

Create a new measure that used the column Repartation. Here is what I wrote

Echantillion = Round(SUM('Table'[Repartition])*21,0) 

then use your measure on the table to get:

If repartition is a measure then you will not need to sum it.

[RPNancy54]

Nb Echantillon = ROUNDUP([Nb Conforme DAP]*0.1,0)

[RPNancy54]

Hello,

Can you help me ? please.

Have a nice day.

[RPNancy54]

Thank you so much

But If i change 21 -> [Nb Echantillon], the result is not OK. It's strange 🤔

Can you help me ?

[apaulso9]

Is Nb Echantillion a column being summed or a measure? Please share the code if it has any. It is strange that the total is 21 even though the column olny adds up to 16 in the picture. I would try remaking the tabler from scratch AND checking to make sure that 'Nb Echantillion' is being used as a whole number of 21. There is a chance that 'Nb Echantillion' is being split by the architecture type. 

[RPNancy54]

Bonjour,

Ci joint l'accés au fichier source. Par avance, merci beaucoup.

A bientot.

https://pmbsoftware-my.sharepoint.com/:u:/g/personal/rafael_pedregal_nrjdiags_fr/EQ75f2P58qlFsuXFYpv... 

[apaulso9]

The problem is that the Echantillon mini multiplies by the categories Echantillion. See below for what I mean:

You can see for each type it is using the Echantillion for that category to multiply by. You want to multiply by the total. I will play around with the code and get back to you!

[RPNancy54]

OK, super. Merci beaucoup !

[apaulso9]

Okay. To make the count fixed for all categories use this code:

Nb Echantillon = Roundup(CALCULATE([Nb Conforme DAP], ALL(Planning[Architecture]))*.1,0)

This means the Nb Echantillion number will be used for all Architecture categories. 

Check out this website if you can https://stackoverflow.com/questions/49019069/dax-measure-value-constant-for-all-entities

[RPNancy54]

Thank you so much.

It's OK.

[apaulso9 · Accepted solution]

It looks as though Repartation is a measure for you. This means you can do what I said above to make a second measure but your code would be:

Echantillion = Round(Repartition*21,0) 

Or you can create a new column on your data table and make it:

Echantillion =Round(Repartition*21, 0) ---this will return a mesure that would show what you want once you drag it onto the table visual.