Forum Discussion

g1davies's avatar
g1davies
Helper I
6 years ago

Divide not working correctly outside a calculation

Hi,

 

I am having issues with a Divide function as part of a measure, the measure is as below.

 

Visitors =
DIVIDE(CALCULATE (
DISTINCTCOUNT ( 'Subscriptions'[ID] ),
FILTER (
GENERATE (
SUMMARIZE (
'Subscriptions',
'Subscriptions'[StartDate],
'Subscriptions'[EndDate]
),
DATESBETWEEN (
'Date'[Date],
'Subscriptions'[StartDate],
'Subscriptions'[Date] )
),
CONTAINS ( VALUES ( 'Date'[Date] ), [Date], 'Date'[Date] )
)
),(DISTINCTCOUNT('Attendance'[ID])))
 
The graph looks like
 
 
 

The bottom two graphs are correct, what seems to be the issue is that the measure is not filtering at all on the Attendance side of the divide function. Any help would be appreciated.

 

Thanks

 

Gavin

 
 
Need Help

1 Reply

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi g1davies 

    it is difficult to help correct but for ujsing all power of filtering and interactive try to conclude DISTINCTCOUNT('Attendance'[ID]) into CALCULATE(), like

    CALCUKATE(DISTINCTCOUNT('Attendance'[ID]))