The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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])
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
8 | |
7 |