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 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
7 Replies
Thank you for answering so quickly. 😁
The filters are all cleared on the visual and the page.
- aj1973
Community Champion
In the service, can you Edit the report and open a new page where you can add a Card and the measure please?
I created a new page and created a card visual. Added that measure.
No change
- aj1973
Try also this (delete FILTER from your measure)
_ProjectOverTime =
DIVIDE(
CALCULATE(
COUNTROWS(CompletedTable), CompletedTable,CompletedTable[overtime] = "FALSE"
),
CALCULATE(
COUNTROWS(CompletedTable), ALLSELECTED(CompletedTable)
)
) + 0
