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

     

affan's avatar
affan
Solution Sage
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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi affan,

     

    Thanks for your support, previously I also used the same logic and got the below result:

     

     

     

    Here is the data at transactional level:

     

    Transaction wiseAfter measure

    I need total amount as -521819.

     

    Thanks