Skip to main content
cancel
Showing results for 
Search instead 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

Reply
mayoconsultinbi
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

 

mayoconsultinbi_0-1706194627393.png

 

 

1 ACCEPTED SOLUTION
Daniel29195
Super User
Super User

@mayoconsultinbi 

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 👍🤠

 

View solution in original post

1 REPLY 1
Daniel29195
Super User
Super User

@mayoconsultinbi 

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 👍🤠

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.