Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Grouping on a data from Analysis services

Hi Team,   Need your help, I am trying to download a report from Analysis Services and data is huge thus exceeding download limits.   I am trying to group the data, however sum is not comming as ...
Need Help
  • affan's avatar
    affan
    7 years ago

    Hi Anonymous,

     

    Can you try using the following measure 

     

    TotalAmount = CALCULATE(SUM(CreditOutputSummary[Amount]),ALLEXCEPT(CreditOutputSummary,CreditOutputSummary[SourcingFileName]))

    If this helped you, please mark this post as an accepted solution and like to give KUDOS .

     

    Regards,

    Affan

     

  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous

         If you connect to Analysis Services by live connection, it can only create the report level measure. it can't create any

    columns or tables.

    and when drag fields into visual and set the aggregate type of field amount to Sum, the visual will automatically

    group aggregated data.

    Best Regards,

    Lin

     

Baskar's avatar
Baskar
Resident Rockstar
7 years ago

Just try sum(amount) ,
why you are trying the Allexcept ?

Do you want to create measure or column ?

If measure just use sum(amount)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Baskar,

 

Sum is also retruing the same result.

How can I create a column?

 

Regards

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous

         If you connect to Analysis Services by live connection, it can only create the report level measure. it can't create any

    columns or tables.

    and when drag fields into visual and set the aggregate type of field amount to Sum, the visual will automatically

    group aggregated data.

    Best Regards,

    Lin