Hello!
I have a measure for a sumx and i need the grand total of it.
Quantity tot of selected =
SUMX(
SUMMARIZE(
Data, Data[ChannelNumber], Data[Date],
"qtyToCalc", IF( [Factory Leadtime raw] <> BLANK(), [Quantity])
),
[qtyToCalc]
)
Is there a way for me to do that?
Solved! Go to Solution.
@Anonymous , Try like
Quantity tot of selected =
calculate(SUMX(
SUMMARIZE(
Data, Data[ChannelNumber], Data[Date],
"qtyToCalc", IF( [Factory Leadtime raw] <> BLANK(), [Quantity])
),
[qtyToCalc]
), allselected())
@Anonymous , Try like
Quantity tot of selected =
calculate(SUMX(
SUMMARIZE(
Data, Data[ChannelNumber], Data[Date],
"qtyToCalc", IF( [Factory Leadtime raw] <> BLANK(), [Quantity])
),
[qtyToCalc]
), allselected())
worked like a charm!