Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement.
In the below table
Dimension is Division
Measure is Count(distinct ID)
Please help me to calculate the percentage like expected output column.
I have tried like Count(distinct ID)/Count(Total distinct ID) but getting wrong percentage.
Please help me on this.
Thanks in advance
do you have Division value as null ?
if Yes you can use this expression:
Count( DISTINCT ID ) / Count( {< Division = {"*"} >} TOTAL DISTINCT ID )
what you tried seems to be right.
let's try adding Count( TOTAL DISTINCT ID ) as a new measure column to see what you get.
do you have Division value as null ?
if Yes you can use this expression:
Count( DISTINCT ID ) / Count( {< Division = {"*"} >} TOTAL DISTINCT ID )