Forum Discussion
pippi
5 years agoFrequent Visitor
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
- AnonymousNot 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