Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

remove constant line from line graph

Hello, Im stuck with a problem i dont know how to solve and why it comes up. Srry for not knowing how to publish a picture directly in this chatbox. But as you can se in the link below i have a lin...
  • Icey's avatar
    6 years ago

    Hi Anonymous ,

    You can change your measure like so:

    Today =
    IF (
        MAX ( 'Idag'[Idag_DateTime] ) <= NOW (),
        CALCULATE (
            COUNT ( View_Current_order_status[Order_id] ),
            FILTER (
                ALL ( 'Today' ),
                'Today'[Today_DateTime] <= MAX ( 'Today'[Today_DateTime] )
            ),
            FILTER (
                ALL ( 'View_Current_order_status' ),
                'View_Current_order_status'[Delivery_date] = DATE ( 2019, 10, 3 )
            )
        ),
        BLANK ()
    )

    Best Regards,
    Icey

     

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