Total value is not working correctly in the Card

[mdaamirkhan]

Hi All,

When I search any ID from the filter its giving incorrect valeu in the card.

I need help on belwo dax to show correct Total value in the card.

Dax: 

Estimated revenue Current year =

var thisYear = year(now())

var val =

CALCULATE([Number of serice month]

,

Filter (Input_Contract_Report, Input_Contract_Report[Active] = "Yes"),

Filter (Input_Contract_Report, Input_Contract_Report[End Date].[Year] ),

ALLEXCEPT(Invoice_Report,Invoice_Report[Contract Code])

)

return

--thisYear

val * [Averge Revenue]

Showing in incorrect value on the card when I add up 3 values:

If I add  3 value from table the  Output will be = 96,715

[PaulDBrown · Accepted solution]

@mdaamirkhan 

Try:

Correct totals = SUMX(Table, [Estimated revenue Current year])

[mdaamirkhan]

Any update?

[amitchandak]

@mdaamirkhan ,

Change return like

sumx(Table, Table[debtor number], Table[Customer Name], Table[contact code], "_1",val * [Averge Revenue]), [_1])

[mdaamirkhan]

Can you please provde full dax query please: