Forum Discussion
SebSchoon1
Post Patron
Post PatronTotal 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...
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 !!
SebSchoon1Post Patron
Post PatronGuys,
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 !!