Hi everyone,
I've recently noticed that some of my reports are not reflecting the values that I see on the desktop client of PowerBI when published to web.
I currently have a calculated column that displays what number number transaction a row might represent for a particular user (Upload number being the transaction number).
The Calculation used is:
Upload number = RANKX(calculatetable(
'public t_negotiations', 'public t_negotiations'[env]= "Production", 'public t_negotiations'[Launched?]="True"
,ALLEXCEPT('public t_negotiations','public t_negotiations'[agent_id])
),
'public t_negotiations'[campaign_launch_date],
,ASC,Dense)
The upload number is a great way for us to track who are our first time users so we can closely monitor their progress.
This column has worked great for a bit over a year now, but recently I've noted that the Web version of PowerBI sometimes adds an extra value i.e. If Upload Number = 1 sometimes it will instead show Upload Number = 2
This only happens on web, and if i republish the report it will sometimes fix the issue. Does anyone have any advice on what might be happening and how I can reduce the probability of this occurring?
