Hi Guru's
I thought this was easy but clearly I have not taken something into consideration.
I have a calculated column which determines the [Trend] of a customer. Which could be Lost, New, Growth or De Growth.
What I am trying to achieve is to create a calculated measure which will tell me what the value for each trend is. Basically 1 calculated measure for each trend which should have a total based on the variance.
You will notice that the value @ a row-level works but the TOTAL for the column is 0. What am I doing wrong?
I include below a screenshot of the issue and include a link to the pbix file i am using for this example.
https://www.dropbox.com/s/1oo1xm2siv9yccm/Trending_Test%20Data.pbix?dl=0
@Anno2019 update your Lost measure to this
Lost =
SUMX( VALUES( 'DATA Sheet'[Customer Name] ),
IF(
[Trend]="Lost",
[Var],
0
)
)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Anno2019 update your Lost measure to this
Lost =
SUMX( VALUES( 'DATA Sheet'[Customer Name] ),
IF(
[Trend]="Lost",
[Var],
0
)
)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
