Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
I have the following table, which in the linearization column gives the total of -66789, but I wanted to put the total of the sum of the Linearization measure on the card. Which gives the value of 10727.
Can you kindly help me?
Measurements :
Backup contract average = trunc(CALCULATE(AVERAGE(HistoricalBases[LinearizedValue]),ALL(HistoricalBases[Fantasy Contract])),2)
Month value = trunc(calculate(MAX(HistoricBases[LinearizedValue]),FILTER(HistoricalBases,HistoricalBases[End of Month] =HistoricalBases[Range])),2)
Linearization = [Average of the backup contract]-[Month amount]
.
I want in card the sum of linearização measure that is 10727 and not -66789.
@felipesaw , Create the measure like
Linearization = Sum(Values(Table[Contracto]), [Average of the backup contract]-[Month amount])
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 |
---|---|
10 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
13 | |
11 | |
8 | |
8 | |
8 |