Forum Discussion

Throgan's avatar
Throgan
Frequent Visitor
3 years ago

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...
Need Help
Throgan's avatar
Throgan
Frequent Visitor
3 years ago

Thank you for answering so quickly. 😁

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

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    3 years ago

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

    • Throgan's avatar
      Throgan
      Frequent Visitor
      3 years ago

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

      No change


       

      • aj1973's avatar
        aj1973
        Icon for Community Champion rankCommunity Champion
        3 years ago

        Please delete the FILTER fucntion from the measure

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Try also this (delete FILTER from your measure)

     

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