Forum Discussion
Solved
Graph items with no data from measure
I have this visualisation (graph) and accomodating table: The promoted count and status count are based off the following measures: Promoted Count =
var prom_count =
CALCULATE(
...
Fixed it by creating a dimension year table and using that YEAR dimension instead of aggregating over the YEAR column in the source data.
There is this "trick" to add 0 to a measure that may return BLANK(). Not a great thing but maybe give it a try.
This does not seem to work. I added 0 to all of the above measures and had no luck.
Promoted Count = var prom_count = CALCULATE( COUNTA([Status]), FILTER(Hockey_About_Years_Cross,[Status] = "Promoted") ) return if(isblank(prom_count),0,prom_count) + 0Status Count = var status_count = counta([Status]) + 0 return if(isblank(status_count),0,status_count) + 0Fixed it by creating a dimension year table and using that YEAR dimension instead of aggregating over the YEAR column in the source data.