undefined

[Anonymous]

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?

[amitchandak]

@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]
)
)