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 Mea...
Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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_))
Adding the step Filter(Input, returns zeros across all the periods...hmmmm
Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Resolved - Not to worry Amit,..