Forum Discussion
Card Visual showing Zero but correct in Desktop
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...
Thank you for answering so quickly. 😁
The filters are all cleared on the visual and the page.
aj1973
Community Champion
Community ChampionTry also this (delete FILTER from your measure)
_ProjectOverTime =
DIVIDE(
CALCULATE(
COUNTROWS(CompletedTable), CompletedTable,CompletedTable[overtime] = "FALSE"
),
CALCULATE(
COUNTROWS(CompletedTable), ALLSELECTED(CompletedTable)
)
) + 0