Forum Discussion
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
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.
Hello,
When I drag Flag_slicer in table it shows 1 but based on condition it should 0 & 1 if conditon mets.
Condtion:
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
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.
Hello,
Thank you. It is working.
Regards,
Chandrashekar B