Measure not uploading to portal on publish

promithius

New Member
Joined
May 12, 2013
Messages
7
Hi folks,

Novice PowerBi user here. I have a strange situatio I can't wrap my head around and wondered if anyone would mind giving me some pointers?

I have a report based on a dataset that pulls from a SQL DB. There is a single table in the report. When I publish to our portal, one of my measures does not appear as part of the dataset on the portal, so the graph displays 100%.

My measure:

Excel Formula:
This Year SLA = 1 - calculate(COUNTA(NASetup[Overdue Status]), FILTER(NASetup,NASetup[Overdue Status] = "true"), FILTER(NASetup, NASetup[Column] = FORMAT((DATE(YEAR(TODAY()),MONTH(Today()),DAY(TODAY()))),"YYYY"))) / calculate(COUNTA(NASetup[Overdue Status]), FILTER(NASetup,NASetup[Overdue Status] = "false"), FILTER(NASetup, NASetup[Column] = FORMAT((DATE(YEAR(TODAY()),MONTH(Today()),DAY(TODAY()))),"YYYY")))

The [column] is the year pulled from a date string - 2 other measures that use this upload fine.

Is there something in this measure that is not supported online?
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,223,701
Messages
6,173,916
Members
452,538
Latest member
ralphtaylor466

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top