Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 !!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.