Forum Discussion
SevsBo
2 years agoResponsive Resident
Field Parameters not working on numeric fields
Hi all, I have just started experimenting with Field Parameters and have so far been unable to make them work. I have a table holds opportunity names, dates, etc, and two types of opportunity...
- 2 years ago
Hello SevsBo ,
create a measure that aggregate the values and reference the measure in the field parameter.
- 2 years ago
Idrissshatila
2 years agoSuper User
Hello SevsBo ,
create a measure that aggregate the values and reference the measure in the field parameter.
SevsBo
2 years agoResponsive Resident
Thanks!
Just to confirm, I used a simple SUM (Value1) and SUM(Value2) as measures and it seems to be working, or would I have to do SUMX or any other aggregation on it?
- Idrissshatila2 years agoSuper User
- SevsBo2 years agoResponsive Resident
Fantastic, thank you again! I think this fundamentally changes how I use Power Bi.
- DAX_pbi_learner1 year agoFrequent Visitor
Hello, I'm having the same issue and just wanted to confirm: are you creating new measures for value 1 and value 2 by suming them and then creating field parameters with those measures?