Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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 ??)
Any reason Whhy this happend?
Solved! Go to Solution.
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 !!
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 !!