cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Calculate grand Total of Max Year

I have a matrix with these sales values, the total sales measure is a calculation of the multiplication of accumulated sales by CPI. I want the grand total shown to be the last year 2024, not the value of the multiplication of the grand total

1 ACCEPTED SOLUTION
Super User

assuming the sales accuum is a measure ipc is a measure

use this logic :

sumx(

values(dimdate[year]),

[sales accum measure] *  [ ipc measure]

)

if both are columns :

sumx(

fact_table,

tablename[sum_accum] * tablename[ipc_value] )

let me know if this works for you.

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠

Super User

assuming the sales accuum is a measure ipc is a measure

use this logic :

sumx(

values(dimdate[year]),

[sales accum measure] *  [ ipc measure]

)

if both are columns :

sumx(

fact_table,

tablename[sum_accum] * tablename[ipc_value] )

let me know if this works for you.

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠