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:
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?
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?