Divide measure by distinct count

Anonymous — Mon, 16 Nov 2020 09:39:04 GMT

I currently have a measure for a pareto chart:

Cumul Events =

VAR thisdate =

MAX ( 'Enhanced line list'[Event Date] )

RETURN

CALCULATE (

[Count],

ALL ( 'Enhanced line list'[Event Date] ),

'Enhanced line list'[Event Date] <= thisdate

)

however I was hoping to get this in % form i.e. rather than a range of 1-1200 for example is it possible to get this as a 0-100% range?

Re: Divide measure by distinct count

amitchandak — Mon, 16 Nov 2020 09:58:25 GMT

Anonymous , Try like

Cumul Events = VAR thisdate = MAX ( 'Enhanced line list'[Event Date] ) RETURN divide( CALCULATE ( [Count], ALL ( 'Enhanced line list'[Event Date] ), 'Enhanced line list'[Event Date] <= thisdate ) , CALCULATE ( [Count], ALL ( 'Enhanced line list'[Event Date] ) ) ) or Cumul Events = VAR thisdate = MAX ( 'Enhanced line list'[Event Date] ) RETURN divide( CALCULATE ( [Count], ALL ( 'Enhanced line list'), 'Enhanced line list'[Event Date] <= thisdate ) , CALCULATE ( [Count], ALL ( 'Enhanced line list' ) ) )

topic Divide measure by distinct count in DAX Commands and Tips

Divide measure by distinct count

Re: Divide measure by distinct count