Forum Discussion
Measure Returns same value for each Period
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.
Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
4 Replies
- amitchandakSuper User
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_))- AnonymousNot applicable
Adding the step Filter(Input, returns zeros across all the periods...hmmmm
- amitchandakSuper User
Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.