Sum Subtotals

Hi SoufTC ,

I find a "mistake". Please let me know if this affects your calculations.

---

 

FaceBook

 

|   Page       |  Likes      |   Followers    |  Date          |

------------------------------------------------------

 | P1            |      32     |         50        |   2021-02-02

 | P1            |      40     |         60        |   2021-02-09

 | P1            |      70     |         100      |   2021-02-16

 | P2            |      80     |        150       |   2021-02-02

 | P2            |      90     |         250      |   2021-02-09

 | P2            |      150   |         350      |   2021-02-16

 | P3            |      10     |         50        |   2021-02-02

 | P3            |      32     |         50        |   2021-02-09

 | P3            |     50      |         80        |   2021-02-16

 

 

What I am expecting are results like:

RESP CONTENT	Last Likes	Last Followers	Community
-  RESP1	220	450	335
P1	70	100	85
P2	150	350	250
-  RESP2	50	40	45
P3	50	40	45
....	.....	....	.....
Total	270	490	380

 

---

The "Last Followers" for "P3" should be "80", instead of "40". And then the "Community" should be "65". Right?

And based on my test, no need to use SUMX in your sample.

Community 3 =
DIVIDE ( [Last Likes] + [Last Followers], 2 )

For more details, please check the attached .pbix file.

Best Regards,

Icey

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