Hour Calculation

Hi Chandrashekar 

I am assuming that Hours ( you are showing is a measure).

Then first Create a disconnected table (Go to Modeling -->New Table (using DAX) )
Flag_Slicer =
DATATABLE(
"Flag_Hrs", INTEGER,
{
{0},
{1}
}
)
and use this in the slicer.

Now create the second measure which will work when you select the slicer it will show (if 1 selected then only above 10 hours rows,  and if 0 selected then it will show below 10 hours rows)

Flag_Filter =
VAR SelectedFlag =
SELECTEDVALUE(Flag_Slicer[Flag_Hrs], -1)

RETURN
SWITCH(
TRUE(),
SelectedFlag = 1 && [Hours] > 10, 1,
SelectedFlag = 0 && [Hours] <= 10, 1,
SelectedFlag = -1, 1, -- Nothing selected
0
)

Then select the visual and apply visual level filter.
AFter selecting the visual got to filter pane and drag Flag_Filter measure and set it to 1

If this answers your questions, kindly accept it as a solution and give kudos.

Hi Chandrashekar ,

I must admit that I don't quite understand your requirements. 

• Flag_hrs should be 1 if the value in the "Hours" column is ??? (What is the exact condition?)
• Flag_hrs should be 0 if the value in the "Hours" column is ??? (What is the exact condition?)
• Is it right that you want a slicer to filter your table by Flag_hrs?