Forum Discussion

SebSchoon1's avatar
SebSchoon1
Post Patron
3 years ago
Solved

Total is not computing after IF

Hi guys,

 

I have a simple IF condition which works, but does not provide any Total.

 

The IF measure

 

REP FIN = 

IF([Rank]<>BLANK() && round([reliquat total],0)>=[Rank],1,BLANK())

 

But only shows

 

 

As you can see After having Added [Partie entière répartition] + [REP FIN] ( which have no totals ??)
I have the correct values on rows but only 9 as total instead of 13

Any reason Whhy this happend?

Need Help
  • SebSchoon1's avatar
    SebSchoon1
    3 years ago

    Guys,

     

    Sorry i just found the SOLUTION !!

     

    Many thanks for you help !!

     

    Here is the formula 

     

    REP FIN 3 = VAR SummaryTable =

        ADDCOLUMNS (

            SUMMARIZE (

                'Tableau Dispatch',

                'Base Article'[CODE ARTICLE],

                'Tableau Dispatch'[CODE DEPOT]

            ),

            "@val",

                VAR REPFIN = [REP FIN 2]

                RETURN

                    REPFIN
        )

    RETURN

        SUMX ( SummaryTable, [@val] )

    Again Thanks to 

     

    johnt75 Who gave me the way to achieve this !!

1 Reply

  • SebSchoon1's avatar
    SebSchoon1
    Post Patron
    3 years ago

    Guys,

     

    Sorry i just found the SOLUTION !!

     

    Many thanks for you help !!

     

    Here is the formula 

     

    REP FIN 3 = VAR SummaryTable =

        ADDCOLUMNS (

            SUMMARIZE (

                'Tableau Dispatch',

                'Base Article'[CODE ARTICLE],

                'Tableau Dispatch'[CODE DEPOT]

            ),

            "@val",

                VAR REPFIN = [REP FIN 2]

                RETURN

                    REPFIN
        )

    RETURN

        SUMX ( SummaryTable, [@val] )

    Again Thanks to 

     

    johnt75 Who gave me the way to achieve this !!