Forum Discussion

pippi's avatar
pippi
Frequent Visitor
5 years ago

Tiles on Dashboard have wrong values when refreshed

I have a visualisation in a report using the Card Visualization.  When I pin this Card to a Dashboard it has the correct value, but, when I refresh the Dashboard the card takes on a new value that is both wrong and I can't work out how it is determined.

 

The value for the card is from a measure, the DAX for the measure is:

 

usersActionNumber = 
// Counts the number of actions for a positon including the actions for positions below them on the org structure
// includes the actions for employees that held the same position code previously
VAR userNom_num = 
LOOKUPVALUE(
    DIM_employeeLookup[searchNod_num], 
    DIM_employeeLookup[userEmail], 
    USERPRINCIPALNAME()
)
VAR positionActions =
CALCULATE(
    DISTINCTCOUNT(FACT_Questions[casenumber]),
        ALL(FACT_WorkOrders) //Remove filters from slicers and visuals
    ,FACT_WorkOrders[IsClosed] = FALSE()
    ,FILTER(
        'DIM_employeeLookup',
        'DIM_employeeLookup'[rsp_nd1] = userNom_num ||  'DIM_employeeLookup'[rsp_nd2] = userNom_num || 'DIM_employeeLookup'[rsp_nd3] = userNOM_num || 'DIM_employeeLookup'[rsp_nd4] = userNom_num
    )
)

RETURN
IF(
    ISBLANK(positionActions), 
    0,
    positionActions
)

 

In my test scenario the formula should return 0 regardless of any slicers on the report.  When I refresh the Report, the card keeps the value of 0.  When I refresh the Dashboard the card takes on the wrong value of 3.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi pippi ,

     

    You are using USERPRINCIPALNAME in the formula, it is a variable quantity. The issue might caused by the different login account?

     

    Best Regards,

    Jay