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. 

10 Replies

  • 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")

        )

    )

     

      • 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.