cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

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

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

Announcements