topic Re: Calculated column from selected value in DAX Commands and Tips

Calculated column from selected value

Anonymous — Tue, 09 Jul 2024 07:06:16 GMT

HI Team,

I'm facing an issue like, i'm want to create a column based on threshold value and placed in Scatted chart based on their values.

Profit_Threshold value: i'm using generateseries function to get this.
Sales_threshold value:- i'm using generateseries function to get this.
Sales_Value: - Sum(sales).
Profit_Value:- Sum(Profit)
I have created calculated column like this,

Quadrant_Column:- if(Sales_value > SelectedValue(Sales_Threshold Value) && Profit_Value > SelectedValue(Profit_Threshold Value), "Top Performers", if(Sales_value < SelectedValue(Sales_Threshold Value) && Profit_Value < SelectedValue(Profit_Threshold Value), "Under Performers","Average Performer")))

Above calculated column is not working.

Using in Scatted Chart.

Could you please help me to get this.

Regards,
Prasad_78

Re: Calculated column from selected value

BeaBF — Tue, 09 Jul 2024 07:36:58 GMT

Anonymous If you want a formula that changes dynamically with the selection in slicer, you need to use a measure.

BBF

Re: Calculated column from selected value

Anonymous — Tue, 09 Jul 2024 07:44:36 GMT

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_78

Re: Calculated column from selected value

BeaBF — Tue, 09 Jul 2024 07:51:10 GMT

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

Re: Calculated column from selected value

Anonymous — Wed, 10 Jul 2024 05:59:16 GMT

BeaBF I didn't see any option to upload pbix file.
Here is the sample data for my requirement.
CustomerSalesRevenueLegends

Customer	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"))

Re: Calculated column from selected value

BeaBF — Wed, 10 Jul 2024 07:12:14 GMT

Anonymous ok, and how is construct your visual? X axis, Y axis, ecc.
Also, Revenue and Sales tables are the distinct of fields in the Table table? I'm recreating your scenario.

Thx,

BBF

Re: Calculated column from selected value

Anonymous — Wed, 10 Jul 2024 07:22:06 GMT

BeaBF In Scater chart,
In values :- Customer
X-axis :- Sales
Y-Axis:- Revenue
Size:- Revenue

Legends:- Calculated_Column.

Re: Calculated column from selected value

BeaBF — Wed, 10 Jul 2024 07:26:13 GMT

Anonymous I't's working for me....

In the graph are you using only fields from the Table table, correct?

BBF

Re: Calculated column from selected value

Anonymous — Wed, 10 Jul 2024 07:31:09 GMT

Yeah. but in slicer i'm using numeric parameter range.

Re: Calculated column from selected value

BeaBF — Wed, 10 Jul 2024 07:34:04 GMT

Anonymous I think this is the issue... can you shere the pbix?

BBF

Re: Calculated column from selected value

Anonymous — Wed, 10 Jul 2024 07:35:33 GMT

@BeaBF I didn't see any option to upload pbix fil here.

Re: Calculated column from selected value

BeaBF — Wed, 10 Jul 2024 07:36:48 GMT

Anonymous you can upload the file in drive and then paste the link

Re: Calculated column from selected value

BeaBF — Wed, 10 Jul 2024 07:39:43 GMT

Anonymous to me it's still working with parameters... i need to see your file to understand the problem

Re: Calculated column from selected value

Anonymous — Thu, 11 Jul 2024 10:04:20 GMT

BeaBF Please find the belwo link

Fields we are using in scatter chart,

In values :- Customer
X-axis :- Sales
Y-Axis:- Revenue
Size:- Revenue

Legends:- Which are calculating the legends column.

Link:- File

Regards,
Prasad_78

Re: Calculated column from selected value

Anonymous — Tue, 23 Jul 2024 10:31:00 GMT

BeaBF Do you have any update.

Re: Calculated column from selected value

BeaBF — Tue, 23 Jul 2024 10:38:38 GMT

Anonymous Hi,

Sorry, my response must not have posted. I've tried countless times, but to dynamically change the legend, you must use a measure, which isn't accepted by the Scatter plot. Therefore, there is no solution.

As a workaround, you can use bookmarks to switch from one chart to another with different legends, but this won't fully achieve the desired functionality. I'm sorry for the bad news.

BBF