- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

How to measure the sum of X table (of this semester) / the sum of X table (of the last semester)
Hello and happy thanksgiving for you all,
I am having this issue with this tables and the formula should be:
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @parisaranda ,
I build a sample to have a test. Firstly add a calculated column : Rank by Year and Semester.
Rank by Year and Semester = RANKX('Table','Table'[Año]*10+'Table'[Semester],,ASC,Dense)
Measure:
Sum of X table (of this semester) / Sum of X table (of the last semester) =
VAR _THIS_Semester =
CALCULATE ( SUM ( 'Table'[Matriculados] ) )
VAR _LAST_Semester =
CALCULATE (
SUM ( 'Table'[Matriculados] ),
FILTER (
ALL ( 'Table' ),
'Table'[Rank by Year and Semester]
= MAX ( 'Table'[Rank by Year and Semester] ) - 1
)
)
RETURN
DIVIDE ( _THIS_Semester, _LAST_Semester )
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @parisaranda ,
I build a sample to have a test. Firstly add a calculated column : Rank by Year and Semester.
Rank by Year and Semester = RANKX('Table','Table'[Año]*10+'Table'[Semester],,ASC,Dense)
Measure:
Sum of X table (of this semester) / Sum of X table (of the last semester) =
VAR _THIS_Semester =
CALCULATE ( SUM ( 'Table'[Matriculados] ) )
VAR _LAST_Semester =
CALCULATE (
SUM ( 'Table'[Matriculados] ),
FILTER (
ALL ( 'Table' ),
'Table'[Rank by Year and Semester]
= MAX ( 'Table'[Rank by Year and Semester] ) - 1
)
)
RETURN
DIVIDE ( _THIS_Semester, _LAST_Semester )
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

could you pls provide the sample data and expected output?
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!

Helpful resources
User | Count |
---|---|
135 | |
124 | |
83 | |
61 | |
46 |