Forum Discussion

Khushboo9966's avatar
Khushboo9966
Helper II
2 years ago

Error while creating calculated fields based on Field Parameter selected

 Hello,   I have attached my PBIX file.  I am facing an error when I use field parameter selection in my calculated formula. The formula(_Standardize_new) won't throw an error when I input a static...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Khushboo9966 ,

 

Are you referring to the incorrect total row calculation? You can consider using the IF() + HASONEVALUE() function to determine if it’s a total. If it is, you can perform calculations based on your requirements, such as average, sum.

Measure 2 =
var _table=
SUMMARIZE('Table',[Group],"Value",[Measure])
return
IF(
    HASONEVALUE('Table'[Group]),[Measure],
    SUMX(
        _table,[Value]))

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Khushboo9966's avatar
Khushboo9966
Helper II
2 years ago

Anonymous  The solution you presented here works when the [Value] is a calculated column. In this case we are using measure name 'measure' to calculate the %. How can I accomplish the sum using the measure option you suggested in the previous pbix file?