Forum Discussion
Different total
Hi sportive92003 ,
Thank you for your reply, according to your request , is one of the following state, see if it meets your needs, I hope my answer to your question will help!You can check my pbix file if you have further questions, I hope this answer meets your needs and I would be honored if I could solve your problem!
Hope it helps!
Best regards,
Community Support Team_ Tom ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hello v-xingshen-msft,
Thats the results expected, it's perfect, but I have some problem to program the variable "coûtant same period - without URÉE". Now it's 0 but I have to program it when we will get a number. The problem is that it's a measure, so I cant use the same formula that you use for the variable MEASURE.
Hi Anonymous ,
Sorry to do not be clear, here are the simple result I expect: URÉE ist just to show and do not be calculated in the total, has you show me how to do, the total for Montant_coûtant in this condition is 864.58K. In the matrix, the actual result should be replaced by this new result (865.58K). Same for the total of the others columns. Ex: "Coutant same period" is the same amount has URÉE is 0, but for the column "DIFF", the total showed should be (57 515.92$) - 3710.49$ = -(61 226.41$) and idem for the %. Is that more clear? Is it possible to do this?
Hi sportive92003 ,
Thank you for your reply, according to your request , is one of the following state, see if it meets your needs, I hope my answer to your question will help!
You can check my pbix file if you have further questions, I hope this answer meets your needs and I would be honored if I could solve your problem!
Hope it helps!
Best regards,
Community Support Team_ Tom Shen
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hello v-xingshen-msft,
Thats the results expected, it's perfect, but I have some problem to program the variable "coûtant same period - without URÉE". Now it's 0 but I have to program it when we will get a number. The problem is that it's a measure, so I cant use the same formula that you use for the variable MEASURE.