cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NishPatel
Helper I
Helper I

Yearly Total in a Column

I have a requirement where I need to use SUM of yearly numbers in a calculation against each row within a year. I am new to this community and not sure if I am able to explain it properly or not. Fiscal Year and Fiscal Month are the two rows in the matrix. Thank You in advance.

NishPatel_0-1615475363463.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@NishPatel , Try one of the two measures with Rate measure

 

calculate([Rate], allexcept(Table, Table[Year]))

 

or

 

calculate([Rate], filter(allselected(Table), Table[Year] = max(Table[Year])))

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@NishPatel , Try one of the two measures with Rate measure

 

calculate([Rate], allexcept(Table, Table[Year]))

 

or

 

calculate([Rate], filter(allselected(Table), Table[Year] = max(Table[Year])))

Hi Amit, If i use this measure in another matrix, the result is not right. So the file I data I shared earlier had Hours by Month. But if i add one more level below (Row under Month), Employee then the number are changed. How can i make this numbers not to change? Thanks again in Advance.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.