79256589

Date: 2024-12-06 00:40:18
Score: 1
Natty:
Report link

This is the sample data I used for test.

enter image description here

I think you need to do the calculation in powerpivot

Total: =
CALCULATE (
    SUM ( Table1[Sales Amount] ),
    FILTER ( Table1, [Product  Use] = "Kitchen" )
)

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
Posted by: Ryan