Forum Discussion
Create Measure and filter by measure
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.
Why?
You don't undestand me?
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.
6 Replies
I'm not following this.
Why?
You don't undestand me?
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.