Forum Discussion
Power Bi Report Builder DAX Result different from DAX studio
Hi, I am using Power Bi Report Builder to generate Dashboard. In these dashboards I need to create a table based on a parameter which give the perimeter for the dashboard. The data collection is ...
bradsy
Microsoft Employee
Microsoft EmployeeHi Lahryco,
You say this was working and on July 9th started to go wrong? If you believe this is a regression in the Power BI service, I suggest you file a support request. They will need a repro if you can make one from sample data.
Hi Bradsy,
Thanks for you feedback. I have found a solution by changing all my requests. I have replaced the way to calculate the__DS0CoreVar, From:
VAR __DS0Core =
CALCULATETABLE(SUMMARIZECOLUMNS(
'Tous PO'[Changed Date],
'Tous PO'[Closed Date],
'Tous PO'[Created Date],
'Tous PO'[Description],
'Tous PO'[Due Date],
'Tous PO'[ID],
'Tous PO'[Link],
'Tous PO'[OASIS_BOOL_ATMO],
'Tous PO'[OASIS_BOOL_EnM],
'Tous PO'[OASIS_BOOL_MOEI],
'Tous PO'[OASIS_BOOL_MOEMRAC],
'Tous PO'[OASIS_BOOL_MOES],
'Tous PO'[OASIS_Code_Marché_Contributeur],
'Tous PO'[OASIS_Code_Marché_Porteur],
'Tous PO'[OASIS_COMOE],
'Tous PO'[OASIS_Criticity],
'Tous PO'[OASIS_Description_Marché_Contributeur],
'Tous PO'[OASIS_Description_Marché_Porteur],
'Tous PO'[OASIS_Entite_Charge],
'Tous PO'[OASIS_Famille_Interface],
'Tous PO'[OASIS_GO_Contributeur],
'Tous PO'[OASIS_GO_Porteur],
'Tous PO'[OASIS_Nom_Marché_Contributeur],
'Tous PO'[OASIS_Nom_Marché_Porteur],
'Tous PO'[OASIS_OBEYA],
'Tous PO'[OASIS_Origine_du_Point],
'Tous PO'[OASIS_Perimetre],
'Tous PO'[OASIS_Remontée_MOA],
'Tous PO'[OASIS_Suivi_Action],
'Tous PO'[State],
'Tous PO'[Title],
'Tous PO'[Work Item Type],
'Tous PO'[OASIS_point_remonte_en_reunion_systeme],
'Table Ligne'[Ligne]
),
__DS0FilterTable
)
To:
VAR __DS0Core =
SELECTCOLUMNS(
CALCULATETABLE('Tous PO',
__DS0FilterTable),
'Tous PO'[Changed Date],
'Tous PO'[Closed Date],
'Tous PO'[Created Date],
'Tous PO'[Description],
'Tous PO'[Due Date],
'Tous PO'[ID],
'Tous PO'[Link],
'Tous PO'[OASIS_BOOL_ATMO],
'Tous PO'[OASIS_BOOL_EnM],
'Tous PO'[OASIS_BOOL_MOEI],
'Tous PO'[OASIS_BOOL_MOEMRAC],
'Tous PO'[OASIS_BOOL_MOES],
'Tous PO'[OASIS_Code_Marché_Contributeur],
'Tous PO'[OASIS_Code_Marché_Porteur],
'Tous PO'[OASIS_COMOE],
'Tous PO'[OASIS_Criticity],
'Tous PO'[OASIS_Description_Marché_Contributeur],
'Tous PO'[OASIS_Description_Marché_Porteur],
'Tous PO'[OASIS_Entite_Charge],
'Tous PO'[OASIS_Famille_Interface],
'Tous PO'[OASIS_GO_Contributeur],
'Tous PO'[OASIS_GO_Porteur],
'Tous PO'[OASIS_Nom_Marché_Contributeur],
'Tous PO'[OASIS_Nom_Marché_Porteur],
'Tous PO'[OASIS_OBEYA],
'Tous PO'[OASIS_Origine_du_Point],
'Tous PO'[OASIS_Perimetre],
'Tous PO'[OASIS_Remontée_MOA],
'Tous PO'[OASIS_Suivi_Action],
'Tous PO'[State],
'Tous PO'[Title],
'Tous PO'[Work Item Type],
'Tous PO'[OASIS_point_remonte_en_reunion_systeme]
)
I will check to open a ticket as it seems to be a regration.
Regards,