Forum Discussion

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

    Fixed it by creating a dimension year table and using that YEAR dimension instead of aggregating over the YEAR column in the source data.

JFG1234's avatar
JFG1234
Frequent Visitor
3 years ago

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) + 0

 

Status Count = 
var status_count = counta([Status]) + 0
return
if(isblank(status_count),0,status_count) + 0
JFG1234's avatar
JFG1234
Frequent Visitor
3 years ago

Fixed it by creating a dimension year table and using that YEAR dimension instead of aggregating over the YEAR column in the source data.