Measure works in Desktop but not in Service

[CarlsBerg999]

Hi,

I have measure that works fine on PBI Desktop but after refreshing on on PBI Service, it produces blank results. What i have is a matrix table as a visual. When i click on refresh in PBI Desktop the calculation produces numbers. I upload the file to PBI Service and it shows fine. However, after a refresh in the PBI Service, the result is always blank. No errors appear, just blank values. 

The measure:

CALCULATE(
SUMX(
SUMMARIZE(
FILTER(
CROSSJOIN('Contract Invoice Schedule',DateTable),
DateTable[Date]>EOMONTH([PARAMETER Forecasts to Actuals],0) // Parameter is a date
&&
DateTable[Date]>=('Contract Invoice Schedule'[Start of invoice rev rec date])
&&
DateTable[Date]<=('Contract Invoice Schedule'[End of invoice rev rec date])),
'Contract Invoice Schedule'[Contract ID & Line Item ID],DateTable[Month & Year],"Amount",
DIVIDE(MAX('Contract Invoice Schedule'[Net Amount]),MAX('Contract Invoice Schedule'[Months]))),[Amount]))

What is causing this?

[haywooda]

I know this is old but I didnt see a solution. I had the same issues where a measure worked fine in PBI desktop but showed blank when published to the service. I set the fields used in the message to explicit data types as i think the service was converting them to different values. This worked for me.

Andy.

[v-kkf-msft]

Hi @Anonymous ,

Has your problem been solved? I cannot reproduct your problem, this is my test PBIX file.

What is your connection mode? Could you please share some sample data?

Best Regards,
Winniz

[Anonymous]

Hi All,

Is there a solution identified for this? I am facing similar issues at work and it is affecting important deliverable.

I have the latest August version of Power BI downloaded. 

The measure works absolutely fine in desktop, but returns blank in service after a refresh. The first image below represents DAX measure values in desptop. Second image represents the blank values in service after refresh.

Table values on PBI desktop

<Blank> values in Service

Any thoughts/comments on why this could be happening?

Best regards,

Pooja

[v-kkf-msft]

Hi @CarlsBerg999 ,

Are you using the latest version of Power BI desktop?  Could you please share your PBIX file without sensitive data?

Is the meature [PARAMETER Forecasts to Actuals] related to the DateTable? After the dataset refreshed, does the meature have a value? 

Best Regards,
Winniz

[lbendlin]

Connect DAX Studio to the dataset in the service, then run the measure query and check for any error messages or compatibility warnings.