Integrate a GENERATESERIES value into another measure

[Orstenpowers]

Dear Community,

I have a working measure, which is as follows:

Specific_V_digit = RIGHT ( LEFT(PCF_V_NUMBER[- Material Desc],15),1)

With V-digit = GENERATESERIES(0, 32, 1) I created a slicer that allows me to enter a figure between 0 and 32.

Now I would like to replace the "15" of the first measure so that it will consider the figure I entered into the slicer.

Entering "19" into the slicer should result in a measure RIGHT ( LEFT(PCF_V_NUMBER[- Material Desc],19),1) etc...

I tried to realize this with V-digit Wert = SELECTEDVALUE('V-digit'[V-digit]) instead of 15, but it did not work...

What do I need to do? Looking for your help I remain

[v-kaiyue-msft]

Hi @Orstenpowers ,

I want to validate the valuable input provided by @jgeddes  and @samratpbi . Their initial thoughts helped guide my approach. However, I noticed that more details are needed to fully understand the problem.

1. create parameters.

2. create measure.

Measure =
RIGHT(LEFT(MAX('Table'[value]),'Parameter'[Parameter Value]),1)

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[Orstenpowers]

Hi @v-kaiyue-msft !

Dear Clara, Thank you very much for your input!

Your parameter and measure works perfectly! Thank you!

However, my request goes somewhat beyond that. Please have a look at the below screenshot. My final and required result would be to see the results of column "Measure" as selectable values for a separate slicer. Looking at this screenshot, the slicer should contain the values 0, 1, 4 and 6.

 

Did I explain it understandable?

[v-kaiyue-msft]

Hi @Orstenpowers ,

You can try using filters on the right hand side of the report to select the appropriate filter to display the desired value.

Also, if you want to use measure as slicer value, you can refer to this solution: Solved: How to use a measure as slicer? - Microsoft Fabric Community.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[Orstenpowers]

Hi @v-kaiyue-msft !
I tried to transfer the measure you provided into the proposed solution at Solution for "How-to-use-a-measure-as-slicer" .

Obviously, I am not skilled enough. 

May I ask you to please assist/ tell me what I need to do?

[Orstenpowers]

Hi @v-kaiyue-msft ,

Thanks for your response!
I will check the link that you provided. Hopefully I get the slicer solution started...

If not, I would come back to you. 🙂

[Orstenpowers]

Hi @v-kaiyue-msft !
I tried to transfer the measure you provided into the proposed solution at Solution for "How-to-use-a-measure-as-slicer" .

Obviously, I am not skilled enough. 😔
May I ask you to please assist/ tell me what I need to do?

[Orstenpowers]

Hi @v-kaiyue-msft !
I tried to transfer the measure you provided into the proposed solution at Solution for "How-to-use-a-measure-as-slicer" .

Obviously, I am not skilled enough. 

May I ask you to please assist/ tell me what I need to do?

[samratpbi]

Hi,

you need to generate a series using Fields parameter first.
Modeling -> New Parameter -> Fields. Generate the fields parameter with min 1 and max 32. 
Now, in the measure you use the measure generated which is:

Series Value = SELECTEDVALUE('Series'[Series], 1)

Now, use this Series Value measure to decide your trim characters.

I created a sample measure to test:

Text Trim =

VAR _text = "abcdefghijklmnopqrstuvwxyz"

RETURN

LEFT(_text,Series[Series Value])

Below is the output:

If this resolves your problem, then please mark it as solution, Thanks!

[Orstenpowers]

Hi @samratpbi,

Thanks for your proposal! After adjusting it slightly, it brings the expected result with your sample text, which is great. 👍

Now it is as follows:

Text Trim =

VAR _text = "abcdefghijklmnopqrstuvwxyz"

RETURN

RIGHT(LEFT(_text,'V-digit'[V-digit Wert]),1)

Now I would need to replace "_text" with PCF_V_NUMBER[- Material Desc], but this I do not get working...do you know what to do?

[jgeddes]

As an example you could use the measure

Extracted Text = 
LEFT(
    SELECTEDVALUE('Table'[Column1]),    //The column that contains the text to be manipulated
    SELECTEDVALUE(Digit[Digit])         //The value selected from the slicer
)

to get a result of 

from the tables

Column1