Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

undefined

Hello All,

We have one Visual page which being used from past 2 years and worked fine but suddenly one measure stopped working and giivng me 0 values. Below is the visual in that visual we are using 3 measures

Billing/Booking =
IF (
    HASONEVALUE ( 'Billing & Booking Switch'[Value] ),
    SWITCH (
        VALUES ( 'Billing & Booking Switch'[Value] ),
        "Billing", [Billing],
        "Booking", [Booking],
        "Backlog", [Current Backlog]
    )
)2 more measures for last year and target as well. It is stopped working from mornign only

Can any one assist?

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , Please check any filter saved by mistake. Ot there is data in tables. Or Data is there for selected values.

     

    Also try this version of formula

     

    IF (
    HASONEVALUE ( 'Billing & Booking Switch'[Value] ),
    SWITCH (
    selectedvalue ( 'Billing & Booking Switch'[Value] ),
    "Billing", [Billing],
    "Booking", [Booking],
    "Backlog", [Current Backlog]
    )
    )