Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
How can I do following: I want to sum the following columns to where it will display the same totals based off criteria for each row. The reason I want to do this is because I want to make a formula to where it will display something like the following:
Issue is now I do a formula but it is summing each line item that makes up the aggregate but does not display the aggregate itself as below with the following formula:
I want it like the picture above so i can eventually breakout and have panel to where I can click and it removes everything that is less than x amount,'
@JMcAnarney1 , based on what I got. one of the two should work
= SUMX(
VALUES('Bid Template Data'[Bid Event]),
CALCULATE(SUM('Bid Template Data'[Total Cost]),filter('Bid Template Data', 'Bid Template Data'[Bidder] = "Engineering Estimate",'Bid Template Data'[Winning Bid] ="No")))
= CALCULATE(SUMX(
VALUES('Bid Template Data'[Bid Event]),
CALCULATE(SUM('Bid Template Data'[Total Cost]),filter('Bid Template Data', 'Bid Template Data'[Bidder] = "Engineering Estimate",'Bid Template Data'[Winning Bid] ="No"))), allselected())
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
11 | |
10 | |
9 | |
8 |