Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

formula to format measures

Can I condititionally format a measure?   For example if a metric is CPC or CTR then to format as a percentage, otherwise as $    
Need Help
Tips and Tricks
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    Based on your description, the easiest way is using the format feature in 'Modeling' ribbon. As a workaround, you may try the following steps.

     

    Here is my example.

    Table:

     

    FormatTable:

     

    Then you may create a measure as below.

     

    FormatSales = 
var _currentformat = SELECTEDVALUE(FormatTable[Format])

return 
IF(
    OR(_currentformat = "CPC",_currentformat = "CTR"),
    MAX('Table'[Sales])/100&"%",
    "$"&MAX('Table'[Sales])
)

     

     

    Result:

     

    Best Regards

    Allan

     

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

v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi, Anonymous 

 

Based on your description, the easiest way is using the format feature in 'Modeling' ribbon. As a workaround, you may try the following steps.

 

Here is my example.

Table:

 

FormatTable:

 

Then you may create a measure as below.

 

FormatSales = 
var _currentformat = SELECTEDVALUE(FormatTable[Format])

return 
IF(
    OR(_currentformat = "CPC",_currentformat = "CTR"),
    MAX('Table'[Sales])/100&"%",
    "$"&MAX('Table'[Sales])
)

 

 

Result:

 

Best Regards

Allan

 

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