Forum Discussion
subhashree_r
Helper I
Helper IDynamic 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...
subhashree_rHelper I
Helper IHi 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])
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
Kelly
Did I answer your question? Mark my post as a solution!