Forum Discussion
Calculated column from selected value
Anonymous
Yes, you can only use a column in the legends field, so a measure will not work.
Maybe having a dis-jointed table with your possible measure results might work, can you share the pbix? to make some tests. It's too difficult to reproduce your case.
BBF
Anonymous If you want a formula that changes dynamically with the selection in slicer, you need to use a measure.
BBF
BeaBF Thank you. But that created one we are using as legend so that's why we are creating a column instead of Measure.
Regards,
Prasad_78Anonymous
Yes, you can only use a column in the legends field, so a measure will not work.
Maybe having a dis-jointed table with your possible measure results might work, can you share the pbix? to make some tests. It's too difficult to reproduce your case.
BBF
BeaBF I didn't see any option to upload pbix file.
Here is the sample data for my requirement.
CustomerSalesRevenueLegendsCustomer Sales Revenue AB 12 54 BC 21 64 CD 31 74 DE 41 23 EF 51 11 Legends = if(Sum('Table'[Sales])> SELECTEDVALUE(Sales[Sales]) && Sum('Table'[Revenue])> SELECTEDVALUE(Revenue[Revenue]),"Top",if(Sum('Table'[Sales])< SELECTEDVALUE(Sales[Sales]) && Sum('Table'[Revenue])< SELECTEDVALUE(Revenue[Revenue]),"Below","Average"))