Dynamic measures based on slicers

[emaioudamari]

Hello,

I have two measures calculating the revenue from two different months, and I need them both for another measure that compares both periods:

Gross Revenue Previous Month =
CALCULATE (
SUMX ( 'FCT_GP-Revenue', 'FCT_GP-Revenue'[Total Revenue] ),
DIM_Accounts[Type 2] = "Revenue",
'FCT_GP-Revenue'[Period] = 4
)

Gross Revenue Current Month =
CALCULATE (
SUMX ( 'FCT_GP-Revenue', 'FCT_GP-Revenue'[Total Revenue] ),
DIM_Accounts[Type 2] = "Revenue",
'FCT_GP-Revenue'[Period] = 5
)

I was hoping to use two slicers to select both periods to compare, instead of using 5 and 4, but I have no idea how to do that. Could anyone please support?

Thank you!

Marianne

[v-xiaoyan-msft]

Hi @emaioudamari ,

I'm not quite sure if I understand your needs accurately.
Sample data without sensitive information and expected output would help tremendously.
Please see this post regarding:

 How to get your question answered quickly 

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

Hope it helps,

Community Support Team _ Caitlyn

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