Forum Discussion

subhashree_r's avatar
subhashree_r
Icon for Helper I rankHelper I
6 years ago

Dynamic Measure change with prefix change in visual

Hello all,      I have two selections , one being sales and another being volume. If I select Sales then it should be shown as ₹ 1000 and if the selection is volume then it should show 1 kg in a bar...
Interesting Links
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

subhashree_r ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
If you using a slicer to change these values. Formatting can not ve dynamic you have to do inside the measure. That might make it text
Appreciate your Kudos.

subhashree_r's avatar
subhashree_r
Icon for Helper I rankHelper I
6 years ago

Hi amitchandak 

  You have understood the problem I'am facing . The Type of the measure is being changed to text. 

 Given below is the measure that I have used :

Sales / Volume selection  = IF(SELECTEDVALUE('Sales / Volume Selection'[Selection ]) = "Sales",SUM(Sales[AMT PRIMARY NET VALUE]),[Volume])
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi subhashree_r ，

     

    A bit confused,so you donnt wanna the result turned out to be a text format?What is your expected output?Can you provide some sample data with expected output for testing?

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!