Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@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,..
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |