Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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])
@Anonymous
You will have to use an iterator like SUMX to aggregate
Something like this
SUMX(TableMain,[Count])
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |