Forum Discussion

molzmad's avatar
molzmad
Helper I
5 years ago

Occupany, Culmulative total help

Hi, i basically have a column labeled occupancy 2, which is a culumaltive total of people entering or exiting a building, im wanting to understand how to modify my DAX so that the occupancy 2 cant go...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

molzmad ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Try

a new column =

if([Occupancy] <0 , 0, [Occupancy])

    • molzmad's avatar
      molzmad
      Helper I
      5 years ago

      I basically need it to do a running total, but if the total goes below zero then to make it zero, as i dont want the occupancy levels going into minus 🙂

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi molzmad ,

         

        It's not clear to me. I did a test. Is the following result what you want?

        Column =
VAR x1 =
    CALCULATE (
        SUM ( 'Enliteon_Office_Test Count_Events'[Ins_Outs] ),
        FILTER (
            ALL ( 'Enliteon_Office_Test Count_Events' ),
            [Custom] <= EARLIER ( 'Enliteon_Office_Test Count_Events'[Custom] )
        )
    )
RETURN
    IF ( x1 < 0, 0, x1 )

        Hope that's what you were looking for.

        Best Regards,

        Yuna

         

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