Variance Chart

[Anonymous]

Hi Team,

slicer select two product id (any two) and expected 3 line like 2 product line and 3rd one is varience line.

can you help me.

Thanks,

[Anonymous · Accepted solution]

Hi @Anonymous ,

The result is this.

The measures I used are

MAX PRODUCT = 
CALCULATE(SUM('Table'[Value]),FILTER('Table',[Product ID]=MAX('Table'[Product ID])))

MIN PRODUCT = 
CALCULATE(SUM('Table'[Value]),FILTER('Table',[Product ID]=MIN('Table'[Product ID])))

Variance = [MAX PRODUCT]-[MIN PRODUCT]

You can check more details from here.

Best Regards,

Stephen Tao

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

[parry2k]

@Anonymous try following measure:

First Product Sales = 
VAR __firstProduct = MIN ( Table[Product] )
RETURN
CALCULATE ( SUM ( Table[Sales] ), Table[Product] = __firstProduct )

Second Product Sales = 
VAR __secondProduct = MIN ( Table[Product] )
RETURN
CALCULATE ( SUM ( Table[Sales] ), Table[Product] = __secondProduct )

Variance = [First Product Sales] - [Second Product Sales]

In matrix visual, put above 3 measure in values section and in the format pane, turn on the option called "Show on rows"

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡