Issues with ISINSCOPE Function

DAX DAX Calculations
1

I am computing values in Power Bi using the ISINSCOPE function but not getting the expected result in my total.

image
image1742×762 74.5 KB

As the image above shows, my values come out correctly in rows but not in the group total or grand total.
I have a measure like so:

 Planned Session Duration = 
  IF (
   ISINSCOPE( DeltaRoom[DeltaRoomCode] ) && ISINSCOPE( xDate[Date] ),
  CALCULATE( MAX( 'Isinscope'[PlannedSessionDuration] ) ), -- get the max planned session duration for this scope
     IF (
         ISINSCOPE( Consultant[ConsultantKey] ) && ISINSCOPE( xDate[Date] ),
         CALCULATE( MAX( 'Isinscope'[PlannedSessionDuration] ) ), -- get the max planned session --duration for this scope
          IF (
                ISINSCOPE( Agency[AgencyName] ) && ISINSCOPE( xDate[Date] ),
                CALCULATE( MAX( 'Isinscope'[PlannedSessionDuration] ) ), -- get the max planned session duration for this scope
                 VAR _PlannedSession =
                   SUMMARIZE( 
                       'Isinscope',
                       'Isinscope'[Date],
                       "PlannedSessionDuration", MAX( 'Isinscope'[PlannedSessionDuration] ) -- get the max value for the scope 
                   )
                   RETURN 
                        SUMX(  _PlannedSession, [PlannedSessionDuration] )  -- return the sum of the max value from the variable to get the total 
          )
   )
)

Not sure where I am getting it wrong. What I hope to achieve is to get the MAX value of PlannedSessionDuration for each row. The MAX value of each row should be summed up as the total per group in the scope so Efficiency is computed like so:

 Efficiency = 
       DIVIDE(
       [Planned Duration(Mins)],
      [Planned Session Duration]
   )

I have attached the file.
Isinscope.pbix (137.5 KB)
Isinscope_Data.csv (106.5 KB)

I really appreciate any help you can provide.

2

Any help on this, please? I’d appreciate your kindness.

3

Hi @upwardD ,

We noticed that your inquiry was left unsolved for quite some time now.
Looks like your inquiry was out of the experts and users’ bounds.

If you were sure you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, your membership also comes with relevant resources that may help you with your Power BI education, so we advise that you check these resources as well.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!