Forum Discussion
Helper ICard shows (Blank) for Measure That Should Have Values
I want to calculate the sum of a few fields in a measure and show it as a card.
The underlying columns in the measure are showing as whole numbers. I have even tried running ISNUMBER formula to check if these are in fact, numbers. However, when I create the measure - the card shows as Blank.
How can I tackle this?
Hi Matt,
In my source data, I had a column for Week Ending based on: =[@[Reporting Ends]]+(7-WEEKDAY([@[Reporting Ends]],1))
Since the Reporting Ends field had time data as well, this was causing the cards to show (blank). In the source file, I changed the Week Ending field to capture only date and Power BI picked up the card metrics.
2 Replies
- MattAllington
Community Champion
In my experience, the result reflects the measure. It is likely you have overlooked something and the formula is wrong. When I tackle these things, i create a table or Matrix, and build something that can test my measures. If it is a complex measure, break it into manageable pieces that you can test.
adilkHi Matt,
In my source data, I had a column for Week Ending based on: =[@[Reporting Ends]]+(7-WEEKDAY([@[Reporting Ends]],1))
Since the Reporting Ends field had time data as well, this was causing the cards to show (blank). In the source file, I changed the Week Ending field to capture only date and Power BI picked up the card metrics.
