Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

  • 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's avatar
      Anonymous
      Not applicable

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

      • amitchandak's avatar
        amitchandak
        Super User

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