Forum Discussion

Chandrashekar's avatar
Chandrashekar
Resolver III
3 months ago
Solved

Hour Calculation

Hello,   How to display Flag_Hrs to 1 if Flag_Hrs greater then 1 or 0 if lesser then 10   and 1 & 0 should display in slicer. PBIX Link: PBIX Link      Regards, Chandrashekar B  
  • mdaatifraza5556's avatar
    mdaatifraza5556
    3 months ago

    Hi Chandrashekar for that create one more measure using below dax

    Flag_Hrs_Display =
    IF(
        [Hours] > 10,
        1,
        0
    )

     

     

    If this answers your questions, kindly accept it as a solution and give kudos.
Hans-Georg_Puls's avatar
Hans-Georg_Puls
Super User
3 months ago

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?
Chandrashekar's avatar
Chandrashekar
Resolver III
3 months ago

Hello,

 

If Slicer selection 1 then Flag_hours should display hours lesser then 10 hours

If slicer selection 0 then Flag_hours should display hours greater then 10 hours

 

Regards,

Chandrashekar B