Forum Discussion

SevsBo's avatar
SevsBo
Icon for Responsive Resident rankResponsive Resident
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.

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

Hello SevsBo ,

 

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

SevsBo's avatar
SevsBo
Icon for Responsive Resident rankResponsive Resident
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 Responsive Resident rankResponsive Resident
      2 years ago

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

  • DAX_pbi_learner's avatar
    DAX_pbi_learner
    Frequent Visitor
    1 year ago

    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?