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!
User | Count |
---|---|
135 | |
63 | |
57 | |
56 | |
46 |
User | Count |
---|---|
139 | |
65 | |
61 | |
60 | |
53 |