Calculating Rate by summary

[erhan_79]

Hi there ;

İ would like to calculate below issue could you pls help me , let me explain pls sceneraio  first : 

i have a table as below which one you can see at left below ; i would like to calculate the rate " Amount"of report for last day on report .

Amount  (summarized ) on status "Actual Monh " total and between "Actual Month + Next Month " Total  ,

i tried to explain below picture what i need , i hope it is clear , thanks in advance for your kind supports 

[ryan_mayu · Accepted solution]

@erhan_79 

Please try below measure

Measure 2 = 
var maxdate=MAX('Table (3)'[repotdate])
var actual=CALCULATE(sum('Table (3)'[amount]),FILTER('Table (3)','Table (3)'[repotdate]=maxdate&&'Table (3)'[status]="actual"))
var actualnext=CALCULATE(sum('Table (3)'[amount]),FILTER('Table (3)','Table (3)'[repotdate]=maxdate))
return actual/actualnext

Hope this is helpful.