Calculate dynamic line for plotting on a line and clustered bar chart

[Anonymous]

Hi All,

I have a many tables and relationships, but to summarize my problem - 

I have a table like below - 

Object	Date	Ct
A	Jan-1	5
A	Jan-2	10
A	Jan-3	15
A	Jan-4	20
B	Jan-1	1
B	Jan-2	2
B	Jan-3	3

I have created a simple measure to get the percentage of count for the object - 

pc_ct = 

var ct_obj = CALCULATE(SUM(Table1[Ct]))

var ct_total_obj = CALCULATE(SUM(Table1[Ct]), REMOVEFILTERS(Table1[Object]))

return ct_obj/ct_total_obj

And plotted a clustered column chart and added a constant line at 5% using the "Analytics" pane of the visual.

My goal is to make that constant line dynamic. The logic is :

the constant threshold line should be = to the minimum % value on the bar chart as long its greater than 5%, else should default to 5%.

For example -

in this chart, it should show at 11%. 

As another example,
If the % ct is say 3%, the constant threshold line should show 5%

In my original data, I have many objects and many filters to slice the data.
I am happy to switch to a line and cluster column chart visual, but I am not sure how to write the DAX measure to get that dynamic constant line.

Any help in this regard would be highly appriciated.

regards

[amitchandak · Accepted solution]

@Anonymous , based on what I got , create a measure and use that in constant line (with new fx option in new release)

measure = minx(Values(Table[object]), [pc_ct])