Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Two Measure Inside If function, One is Value and One is Percentage

Hi Pro's,   I have measure which contains two measure and display result based on If condition: -  IF ( MAX ( DimDrawer[MainDrawerName] ) = "Gross Margin", 'Key Measures'[Gross Margin], CALCU...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi Anonymous ,

 

Try to use format function in formula.

IF (
MAX ( DimDrawer[MainDrawerName] ) = "Gross Margin",
FORMAT('Key Measures'[Gross Margin],"##%")
CALCULATE ( 'Key Measures'[BalanceSC] )
+ CALCULATE ( SUM ( 'FA Forcast'[Value] ), 'FA Forcast'[Version] = "C.Forecast" )
)

 

 

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for reply.

 

I tried but not working. Same issue. Do you have any other option.

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Unfortunately, I can't reproduce your issue. see if you can share the sample pbix file.

    Please mask any sensitive data before uploading

     

    Best Regards,

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