measure in a slicer

[Giada_Togliatti]

Hi, 

I've this formula:

% =

VAR activitystart =MAX ( Fact_Pianificazione[Data_Inizio_Pianificata] )

VAR activityend = MAX ( Fact_Pianificazione[Data_Fine_Pianificata] )

VAR selecteddate = TODAY()

VAR activitytotaldays = activityend - activitystart + 1

RETURN

SWITCH (

TRUE (),

activityend <= selecteddate, 1,

activitystart <= selecteddate

&& activityend > selecteddate,

( selecteddate - activitystart + 1 ) / activitytotaldays,

activitystart > selecteddate, 0

)

This gives me result from 0 to 100

I need to create something that filter result= 0 and result different from 100 and put it in a slicer.

How can I do?

Thank you

[v-easonf-msft · Accepted solution]

Hi, @Giada_Togliatti 

Measure cannot be applied to the slicer, it is recommended to convert the measure into a calculated column．

%_column = 
VAR activitystart = Fact_Pianificazione[Data_Inizio_Pianificata]
VAR activityend = Fact_Pianificazione[Data_Fine_Pianificata]
VAR selecteddate = TODAY()
VAR activitytotaldays = activityend - activitystart + 1
RETURN
SWITCH (
TRUE (),
activityend <= selecteddate, 1,
activitystart <= selecteddate
&& activityend > selecteddate,
( selecteddate - activitystart + 1 ) / activitytotaldays,
activitystart > selecteddate, 0
)

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Giada_Togliatti , You need to generate a series from on to 100 . And the create new measure where values from this new table = %

Example

percent = generateseries(1,100,1)  //0.1 or .01 as step based on values 

new measure = countx(values(Fact_Pianificazione[ID]), if([%] = max(percent[Value]), [ID], blank()))

Where ID is group by need for measure values to me in range from 0 to 100

refer my video for more details

https://youtu.be/CuczXPj0N-k

or

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization