Different total

[sportive92003]

Hello,

simple question, I just would like to show the option "Urée" but not be included in the total. My total should be 868 295,47 - 3 710,49. Any solution to fix it?

[Anonymous · Accepted solution]

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.

[FreemanZ]

hi @sportive92003 ,

Try like:New Measure = 

IF(  

    MAX(table[column])="UREE",

    SUM(table[value]),

    CALCULATE(

        SUM(table[value]),

        KEEPFILTERS(table[column]<>"UREE")

    )

)

[sportive92003]

Thank you for your help! But the result is the same.

[FreemanZ]

hi @sportive92003 ,

Not sure if i fully get you, supposing you have a data table like:

try to plot a visual with region column and a measure like below:

Measure = 
IF(
    MAX(data[Region]) = "South",
    SUM(data[Sales]),
    CALCULATE(
        SUM(data[Sales]),
        KEEPFILTERS(data[Region]<>"South")
    )
)

it worked like:

[sportive92003]

Thank you FreemanZ, I've programmed and the result is the same amount. I'm curious to know why it works on your side and not mine. The next post of v-xingshen-msft. I've got the rigt result. The next step is how to include it in the me matrix. 

[Anonymous]

Hi ALL,
Firstly  FreemanZ  thank you for your solution!
And @sportive92003 ,As I understand it you want to show the sum in the total column, but not the ure, right?
If you want to display the total value only in the card, then you can use the first CALCULATE function in my judgment condition, if you want to display it in the matrix then you can use the full formula.

MEASURE = 
IF (
    NOT ( ISINSCOPE ( 'Table'[cprodds] ) ),
    CALCULATE (
        SUM ( 'Table'[Montant_coûtant] ),
        FILTER ( 'Table', 'Table'[cprodds] <> "URÉE" )
    ),
    SUM ( 'Table'[Montant_coûtant] )
)

I hope my method is helpful to you, if my method can help you solve the problem I will be honored!

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.

[sportive92003]

Hello,

that works! The result is right. Next step is how to include it in my matrix for all columns (coutant same perios, DIFF, % DIFF) in replacment to the actual total ?

[Anonymous]

Hi @sportive92003 ,
I'm glad that my formula can help your problem, but I still do not understand what your current needs, your total column is currently correct, whether you can speak of your needs in more detail, or show you want to achieve the effect of the view so that it is more convenient for us to discuss, look forward to your reply!I'm glad that my formula can help your problem, but I still do not understand what your current needs, your total column is currently correct, whether you can speak of your needs in more detail, or show you want to achieve the effect of the view so that it is more convenient for us to discuss, look forward to your reply!

[sportive92003]

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?

[Anonymous · Accepted solution]

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.

[sportive92003 · Accepted solution]

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.