Forum Discussion
Measure help
You have put all of your parentheses at the end! Try:
Margin% = IF(SUM(Inbound[NER_FYTD_Constant])=0,0,SUM(Inbound[MarginFYTD_Constant])/SUM(Inbound[NER_FYTD_Constant]))
Hope this helps!
AnonymousChristann
Actually the output is not showing in % and should be one place decimal
is there anything we need to tweek in this measure?
The formatting is not included in the actual Measure. You can simply select the measure in your Fields pane, and then modify the formatting on the Modeling tab > Formatting.
Great, this helps & an easy one.
Can you also help me on more issue, i have a metrics, where i want to show the upward and downward trend, something like shown in below (which is basically an indicator )
Not sure, how do i achieve this, as i don't find any option to do that
I am not sure what you are asking. Are you looking for how to create Conditional Formatting(i.e. text or background changes color based on the value), or are you wondering how to create the whole combination of graphics in your screenshot?