cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mloc1990 Frequent Visitor
Frequent Visitor

Measure calculates individual volumes correctly but the total is incorrect

Hi 

 

I am trying to create a measure that when nothing is selected the default total value is the Total Gross Exposure for all accounts in my Power BI report . The below measure calculates correctly when selecting individual accounts however the default value when nothing is selected is only the most recent days total volume instead of all gross exposure.

 

Thanks,

 

 

Max Gross Exposure = CALCULATE(SUM(underwritingndx[volume]),FILTER(underwritingndx,underwritingndx[authdate] > MAX(underwritingndx[maxexposurestartdate])))
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Measure calculates individual volumes correctly but the total is incorrect

@mloc1990 try changing measure to

 

Max Gross Exposure = SUMX( VALUES( underwritingndx[Account] ),
CALCULATE(SUM(underwritingndx[volume]),FILTER(underwritingndx,underwritingndx[authdate] > MAX(underwritingndx[maxexposurestartdate]))))





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

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

2 REPLIES 2
Super User
Super User

Re: Measure calculates individual volumes correctly but the total is incorrect

@mloc1990 try changing measure to

 

Max Gross Exposure = SUMX( VALUES( underwritingndx[Account] ),
CALCULATE(SUM(underwritingndx[volume]),FILTER(underwritingndx,underwritingndx[authdate] > MAX(underwritingndx[maxexposurestartdate]))))





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

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

mloc1990 Frequent Visitor
Frequent Visitor

Re: Measure calculates individual volumes correctly but the total is incorrect

@parry2k 

 

This looks to be exactly what I need thanks for your help! 

 

If I were to have another measure where the maxexposurestartdate was replaced with medexposurestartdate would it work like below? I was expecting a different amount but they both return the same total figure

 

Med Gross Exposure = SUMX( VALUES( underwritingndx[Account] ) ,
CALCULATE(SUM(underwritingndx[volume]),FILTER(underwritingndx,underwritingndx[authdate] > MAX(underwritingndx[medexposurestartdate]))))

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,826)