Variance chart/Table for one table

[Anonymous]

Hi Friends,

I need your help!

I have one source file with two different countries data, after slicer I need both country variance in one  visual.

Please help on Variance visual chart/tbl.

[Mariusz · Accepted solution]

Hi @Anonymous 

Please see the attached file with a solution,

Let me know how you get on or if you stuck.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Thanks for your help, I need one more query,

1. Country left & right table instead of only one common table like Country

2. Country table multiple column like Country name, UID, Region

3. Country table relationship with source file (Country to Country )

Now how can I get Variance value,

Please advise me.

@Mariusz 

Thanks,

Kalidass

[Mariusz]

Hi @Anonymous 

Can you explain these requirements a bit more, as I'm struggling to understand what you need?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

1. Country left & right table instead of only one common table like Country

2. Country table multiple column like Country name, UID, Region

3. Country table relationship with source file (Country to Country )

Now how can I get Variance value

@Mariusz 

[dax]

Hi @Anonymous , 

You could refer to my sample for details.

Best Regards,
Zoe Zhi

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

[Mariusz]

Hi @Anonymous 

Can you share the data sample?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Hi,

Please find below sample,

@Mariusz 

[Mariusz]

Hi @Anonymous 

Thanks, but can you paste the actual data so it can be used as a sample?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn