Conversions %

[manideep547]

Hi all,
I have a table  with Id, Destination, date columns 
I created three tables destination1 ,destination2 ,Ids
Destination1= SUMMARIZE(FILTER('Table,'Table'[DESTINATION]<>blank()),'Table'[DESTINATION])
Destination2=Destination1
ID = SUMMARIZE(FILTER('Table','Table'[ Id]<>blank()),'Table'[Id])
And my model is 
Destination1[Destination] to Table[Destination]  One too many and cross filter direction single and Active relationships
Destination2[Destination] toTable[Destination]  One too many and cross filter direction single and Inactive relationships
Table[Id] toID[id]  One too many and cross filter direction single and Active relationships
And below measure gives me the Cross destinaion visits distnctcount 
That means 

Cross destination =
CALCULATE(
DISTINCTCOUNT('Table'[Id]),
CALCULATETABLE(
SUMMARIZE(Table',' Table'[Id]),
ALL(Persona1),
USERELATIONSHIP('destination2'[destination], Table'[destination])
)
)+0
A1(Destination)count=2
A2(Destination)count=2
Destination1 table placed as the slicer
and Cross destinaion measure is filter by destination2 table in filter panel (card)

count 1 is one customer are common in both destination 
Those customers who are in A1 Destination and also in A2 Destination, count=1
Now I need the Conversions % that means numbers of customers who are converted to another Destination from A1 
total number of customers in A1 destination =2
Number of customers converted to another destinations is 1
Total number of customers in selected destinations is 5 
I need (1/5)*100=20%
Calculation (1/5)*100 =20%

YOU CAN FIND MY .pdix file  
https://drive.google.com/file/d/1pwosx8F6-8e-xVxVNAltx1cgeF55Pvsj/view

can any help me out, I need to submit it today please

[v-jayw-msft · Accepted solution]

Hi @manideep547 ,

You can try EXCEPT() function.

Measure = 
CALCULATE(
    DISTINCTCOUNT('Table'[ID]),
    CALCULATETABLE(
        SUMMARIZE('Table', 'Table'[ID]),
        EXCEPT(ALL(Destination1),ALLSELECTED(Destination1)),
        USERELATIONSHIP(Destination2[Destination], 'Table'[Destination])
    )
)+0

 Then use the formula below to calculate percentage.

Measure 2 = FORMAT([Measure]/COUNTROWS(ALL('Table')),"percent")

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.