Forum Discussion

SevsBo's avatar
SevsBo
Icon for Continued Contributor rankContinued Contributor
2 years ago
Solved

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...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    Hello SevsBo ,

     

    create a measure that aggregate the values and reference the measure in the field parameter.

  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    SevsBo ,

     

    the SUM (Value1) and SUM(Value2) would do the work.

SevsBo's avatar
SevsBo
Icon for Continued Contributor rankContinued Contributor
2 years ago

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?

Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
2 years ago

SevsBo ,

 

the SUM (Value1) and SUM(Value2) would do the work.

  • SevsBo's avatar
    SevsBo
    Icon for Continued Contributor rankContinued Contributor
    2 years ago

    Fantastic, thank you again! I think this fundamentally changes how I use Power Bi.