Use parameter in measure

[ahuhn]

I have a simple dataset

Status	MonthUpdated
Alpha	201810
Alpha	201810
Beta	201810
Gamma	201810
Delta	201809
Alpha	201809
Alpha	201809
Alpha	201808

What I want to do is create two parameters so the user can find the difference in counts between two months. I want the user to select month1 = their choice (preferaby from a table or dropdown), select month2 = their choice as well. ie difference between 201810 and 201809 for Alpha status is 0, but 201810 and 201808 is 1

So far, I tried:

1) Measure = CALCULATE(COUNT(Sheet1[Status]),FILTER(Sheet1,[MonthUpdated]=YYYYMM && [Status]="Alpha")), but this does not update when I change the parameter value YYYYMM via home --> edit queries --> edit parameters

2)  Following from https://community.powerbi.com/t5/Desktop/use-parameters-in-dax/m-p/536964/highlight/false#M251956 does not work, as this uses slicers, and after selecting for one month via a slicer table, the second selection is limited to the value of the first slicer,

3) Following https://community.powerbi.com/t5/Desktop/Use-parameter-in-measure/m-p/349842#M157174 failed because the what-if parameter permits only continuous numeric values.

Suggestions are most appreciated

[Greg_Deckler · Accepted solution]

I would use two disconnected tables with your values and two slicers. Use MAX to grab the value of your slicer. You could create your tables by using something like:

Table1 = DISTINCT('Table'[MonthUpdated])

Table2 = DISTINCT('Table'[MonthUpdated])

Don't relate them to anything.