Divide not working correctly outside a calculation

[g1davies]

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

[az38]

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]))