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
erhan_79
Post Prodigy
Post Prodigy

Calculating Rate by summary

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 Capture-19.JPG

 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@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

1.PNG

Hope this is helpful.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
ryan_mayu
Super User
Super User

@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

1.PNG

Hope this is helpful.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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.