Card Visual showing Zero but correct in Desktop

[Throgan]

I have a Card visual that shows correctly in Desktop but shows zero in the Service.

I verified that the DAX works in desktop, there is data in the table, and I refreshed the data in the workspace and updated the app a few times just to make sure.

Has anyone fixed this issue before?

Power BI Desktop

Power BI Service

If the problem could be a DAX issue:
Here is the DAX I am working with to calculate the percentage of projects needing overtime. The column is Text with TRUE or FALSE as the only values.

_ProjectOverTime =
DIVIDE(
CALCULATE(
COUNTROWS(CompletedTable),
FILTER(CompletedTable,CompletedTable[overtime] = "FALSE")
),
CALCULATE(
COUNTROWS(CompletedTable), ALLSELECTED(CompletedTable)
)
) + 0

[Throgan]

Thank you for answering so quickly. 😁

The filters are all cleared on the visual and the page.

[aj1973]

Try also this (delete FILTER from your measure)

_ProjectOverTime =
DIVIDE(
CALCULATE(
COUNTROWS(CompletedTable), CompletedTable,CompletedTable[overtime] = "FALSE"
),
CALCULATE(
COUNTROWS(CompletedTable), ALLSELECTED(CompletedTable)
)
) + 0

[aj1973]

In the service, can you Edit the report and open a new page where you can add a Card and the measure please?

[Throgan]

I created a new page and created a card visual. Added that measure.

No change

[aj1973]

Please delete the FILTER fucntion from the measure

[Throgan]

I found the issue. 

The service wasn't picking up the change on the column from True/False to Text.

In Transform Data, I switched that column from Text to True/False and then back to Text.

When I saved and refreshed, the service had the correct data in the visual.

Thank you for your help. 🙂

[aj1973]

Hi @Throgan 

Is there any filters applied in the service compared to what's in the Desktop?