Use lower border from slicer in measure

[thomasreick]

Hi all,

can you please give a hint on the following:

Imagine a fact table of Customers with Turnover.

I would lik e to show all customers above a certain turnover border (which is not necessarily from to the realised turnovers in my fact table!)

Means: I want to define the border by myself e.g. €250.000.

• This figure of €250.000 needs to be shown in a Measure calculating the textstring for the headline of the page/the chart.
• e.g. "All Customers with turnover > €250.000"
• I have taken a slicer-visual and loaded it with the turnovers from my fact table.
• I reworked slicer settings to work as "greater than or equal"

The slicer works as expected, but I cannot get the selected value (€250.000 as keyed-in) to be displayed it in the headline.

Can you please give a hint on the DAX I should use?

Headline = IF(ISFILTERED(my_facts[Amount]);"All Customers with turnover > " & the-lower-border-from-the-slicer;"All customers"

thx in advance

Thomas

[Duia · Accepted solution]

Hi  @thomasreick ,

I created some data:

Here are the steps you can follow：

1. Create a table by Modeling - New parmeter as a slicer.

2. Create measure.

Title =
"All Customers with turnover"&"> "&SELECTEDVALUE('Parameter'[Parameter])

Flag =
var _select=
SELECTEDVALUE('Parameter'[Parameter])
return
IF(
    MAX('Table'[turnover]) >_select,1,0)

3. Click Visual -- Format's Title -- fx.

Go to Title text - select Measure[Title]

Result:

Title will display the corresponding value as the slicer is selected:

4. Place [Flag]in Filters, set is=1, apply filter.

5. Result:

The value in the Visual will appear larger than the value selected by the slicer:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[thomasreick]

Hi amitchandak,

thank you for your input, but I do not get it...

You wrote:  Countx(FIlter(Values(Customer[Customer]) , [Measure] >2500) , [Customer])

Referring to the Part '[Measure]>2500': the number should be the Lower-Border of  a Slicer which is based on the turnovers per customer (setting of the slicer is 'greater than or equal'). So the Slicer' output should be referenced...

Whilst the Turnovers are realised numbers (e.g. €15,365.27) the slicer is possible to have individual numbers to select (e.g €12,345, using this value the reaslised turnover of 15,365.27 is included in the COUNT()).

Or...is it better to create a variable 'MyVariable' holding the the lower border from the slicer after setting the slicer and use this variable inside the Headline string (lblHeadline = "Customers shown with Turnover >= " & MyVariable?

thank you in advance for your input.

thx

Thomas

[amitchandak]

@thomasreick , Based on what I got

Countx(FIlter(Values(Customer[Customer]) , [Measure] >2500) , [Customer])