Forum Discussion

JB140's avatar
JB140
New Member
6 years ago
Solved

Grouping Data

Hi All,   I have values seperated by different categories ( DISC 1, DISC 2, DISC 3, CORP, ETC) within a dataset using Azure Analysis Service as a live connection to retrieve the data.   Without a...
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi JB140 ,

    Since you cannot create a calculated column under Live Connection mode, you can create a measure named [Saver] like this and use it in the bar chart:

    Saver = SUM(Sheet1[DISC1]) + SUM(Sheet1[DISC2]) + SUM(Sheet1[DISC3])

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi JB140 ,

Since you cannot create a calculated column under Live Connection mode, you can create a measure named [Saver] like this and use it in the bar chart:

Saver = SUM(Sheet1[DISC1]) + SUM(Sheet1[DISC2]) + SUM(Sheet1[DISC3])

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.