How to calculate Difference from Base Line (like FireBase in AB testing)

[Huongluu]

Hello Every One,

I am newbie in Power BI

I want to controll all Firebase AB testing of all projects in a dashboard. 

- I get all data from Bigquery 

- I mark 0 is control user, 1 is target user

My table like: 

ID_AB_Unit	Experiment_Variant	User_pseudo_id	Version	Revenue
firebase_exp_13	1	id1	3.5.3	1.0
firebase_exp_13	0	id2	3.5.3	1.1

When I calculate % Difference Experiment with baseline but I cannot get valid result

Current solution: 

- Make base table from origin table relationships is ID_AB_Unit:

ID_AB_Unit	Experiment_Variant	User_pseudo_id	Version	Revenue
firebase_exp_13	0	id2	3.5.3	1.0
firebase_exp_13	0	id4	3.5.3	1.1

Then calculate base revenue from base table, calculate experiment revenue from origin table -> DIfference revenue. It seem like working but wrong when I filter by version in origin table  

Any idea with this situation?

[v-henryk-mstf]

Hi @Huongluu ,

Can you provide some test data to facilitate me to answer for you as soon as possible.

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Looking forward to your reply.

Best Regards,
Henry