Forum Discussion

Lahryco's avatar
Lahryco
New Member
2 years ago

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 ...
Need Help
bradsy's avatar
bradsy
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Hi 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.

  • Lahryco's avatar
    Lahryco
    New Member
    2 years ago

    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,