Measure Returns same value for each Period

[Anonymous]

Hi Experts

I have filter the date in the FACT Table to validate my SelectedValue and i am getting the same value return for each of the Month abbervation i.e. M1, M2, M3, M4, M5 and so on

Measure

Fee =

VAR P = SelectedValue(Input[Time Period no])

VAR MonthYear = SelectedValue(Control Tab[Month Control Selection])

VAR _int = SelectedValue(Input[BB])

VAR Result = Calculate([Value],
                   Input[Year] = MonthYear,
                   Input[M Column] = "M1",

                   Input[Terms] = "Fee",

                   Input[BB/FF] = "BB",

                   Input[Time Period] = p,
                   Input[Rate] = _int_)
Return

Result

The Value for M1 = 10 as end result which is correct but is give me 10 for M2,M3,M4 and so...when they should be zero.

[amitchandak]

@Anonymous  change result like

and try

VAR Result = Calculate([Value],filter(Input,
Input[Year] = MonthYear &&
Input[M Column] = "M1" &&
Input[Terms] = "Fee" &&
Input[BB/FF] = "BB" &&
Input[Time Period] = p &&
Input[Rate] = _int_))

[Anonymous]

Adding the step Filter(Input, returns zeros across all the periods...hmmmm

[amitchandak · Accepted solution]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Resolved - Not to worry Amit,..