Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    7 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's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion

    Anonymous 

     

    You will have to use an iterator like SUMX to aggregate

    Something like this

     

    SUMX(TableMain,[Count])

    • Anonymous's avatar
      Anonymous
      Not 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])