Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
SebSchoon1
Post Patron
Post Patron

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

 

SebSchoon1_0-1664184430406.png

 

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?

1 ACCEPTED SOLUTION
SebSchoon1
Post Patron
Post Patron

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 !!

View solution in original post

1 REPLY 1
SebSchoon1
Post Patron
Post Patron

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 !!

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors