Forum Discussion
count of summarize
Question:
The TableMain at the bottom returns a table with data correctly.
VAR TableMain =
FILTER (
SUMMARIZE (
Table1,
Table1[Field1],
Table2[Field1],
Table1[Field2],
"Count", DISTINCTCOUNT ( Table3[Field2] ),
"Total Sales", [MyMeasure]
),
[Total Sales] > 10
)
Question:
How do I do a sum (In a separate measure) for the column "Count" in table TableMain ?
The following count dax does not work:
CALCULATE(SUM(Mandates[Count]))
Thank you
- Anonymous7 years ago
Thank you
Zubair_Muhammad wrote:Anonymous
You will have to use an iterator like SUMX to aggregate
Something like this
SUMX(TableMain,[Count])
Zubair_Muhammad wrote:Anonymous
You will have to use an iterator like SUMX to aggregate
Something like this
SUMX(TableMain,[Count])
2 Replies
- Zubair_Muhammad
Community Champion
Anonymous
You will have to use an iterator like SUMX to aggregate
Something like this
SUMX(TableMain,[Count])
- AnonymousNot applicable
Thank you
Zubair_Muhammad wrote:Anonymous
You will have to use an iterator like SUMX to aggregate
Something like this
SUMX(TableMain,[Count])
Zubair_Muhammad wrote:Anonymous
You will have to use an iterator like SUMX to aggregate
Something like this
SUMX(TableMain,[Count])