DAX / Matrix Syncing Error.

DAX DAX Calculations
1

Hi DNA Team,

I was wondering if anyone can provide some assistance with a problem I’m experiencing with my Dashboard.

Its a bit of a strange one as i’ll do my best to explain it clearly.

I’ve created a Matrix in the Dashboard (see GDL Dashboard Final Attached).

This matrix is 4 levels deep:

  • Level 1 DPC 1.
  • Level 2 Trade.
  • Level 3 Main Task.
  • Level 4 Sub Task.

The goal at each level of the matrix:

Level 1 - Show Column [Main Task Status]
Level 2 - Show As Blank
Level 3 - Show Column [Sub Task Status]
Level 3 - Show Column [Sub Task Status]

The Task Status Measure seems to be working on in PowerBI.

image

However, when I upload this Dashboard to the PowerBI service the DAX has been altered.

image

Also if i make changes to the underlying Data Source being a SharePoint List is seem to add Multiple Values in the Task Status Column.

Any help on this would be appreciated, as Im not sure its a DAX issue or some kind of browser cache or sync issue with the service.

GDL Dashboard - Final.pbix (177.4 KB)

Thanks, Adam.

2

How has the DAX been altered in the published report? I’ve never heard of that.

This sounds like a sync issue between the published report and the sharepoint data or potentially a structural change in the sharepoint file.

3

Thanks @HufferD,

Yeah it’s a strange one. I’m not even sure how to go about fault finding this.

Thanks, Adam

4

I’m curious about your statement “…when I upload this Dashboard to the PowerBI service the DAX has been altered.” In what way is the DAX altered and how do you know?

5

Hi @adam,

I had issues doing Power BI reporting against a Dataverse data source where multi-choice columns were defined in the database. When using the OAuth API to connect, those columns returned crazy stuff like a long sequence of numbers. I switched to the (new at the time) Dataverse data source provider, and most of the issues went away, such that I got the selected value in the column. However, not all of the issues went away.

My understanding is that there is some kind of translation of the multi-choice value fields going on in the data source provider, and if A) the provider understands the source’s multi-choice column data and B) the column is actually defined and populated the way it is supposed to be, then you get back the values you expect. Anything out of sorts and you get a non-useful value back.

My educated guess with your scenario is that you have the required data provider or provider version on your machine where Power BI Desktop is running, and the Power BI service does not (or at least doesn’t understand the data source).

I hope this helps with finding the issue.

John

1 Like