Forum Discussion

sportive92003's avatar
sportive92003
Helper II
1 year ago
Solved

Different total

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's avatar
    Anonymous
    1 year ago

    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's avatar
    sportive92003
    1 year ago

    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. 

FreemanZ's avatar
FreemanZ
Super User
1 year ago

hi sportive92003 ,

 

Try like:New Measure = 

IF(  

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

    SUM(table[value]),

    CALCULATE(

        SUM(table[value]),

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

    )

)

 

  • sportive92003's avatar
    sportive92003
    Helper II
    1 year ago

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

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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's avatar
        sportive92003
        Helper II
        1 year ago

        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 ?

         

         

    • FreemanZ's avatar
      FreemanZ
      Super User
      1 year ago

      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's avatar
        sportive92003
        Helper II
        1 year ago

        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.