Create Measure and filter by measure

[Grizman]

I have two table:

First have column: Id_product, ProductName, Q-ty in 2017

Second: ID, ProductPrice in 2015, ProductPrice in 2016, ProductPrice in 2017

I need create two measures:

1. Comparison 2015 vs 2016

2, Comparison 2016 vs 2017

which reveal GrossTurnever=Q-ty*ProductPrice for every year and Margin=GrossTurnever2016-GrossTurnever2015 

In Filter I want watch measures with chekbox:

2015 and 2016 - first measure

2016 and 2017 - second measure 

User must have select different combination comparison.

[Grizman · Accepted solution]

Why?

You don't undestand me?

[Greg_Deckler]

I'm not following this.

[Grizman · Accepted solution]

Why?

You don't undestand me?

[Greg_Deckler · Accepted solution]

Correct, it is very difficult to picture what you are trying to accomplish. Perhaps post some sample data and an example of what you want to achieve.

[Grizman]

Can anybody help me?

Please!

[Grizman]

Can anybody help me?

[Grizman]