Forum Discussion

AndrewDang's avatar
AndrewDang
Helper IV
10 years ago

Help with Clustered Column Chart

Hello all;   This could be a dummies question but here is the scenarios:   I have created a clusterred Column Chart to compare monthly values for 2015 and 2016.  I have a line value to measure a ...
Sean's avatar
Sean
Community Champion
10 years ago

AndrewDang

 

Set Date 2015 = CALCULATE(COUNTA('Meters Sold vs Set'[Set Date]), 'Date Dimension'[Year] = 2015)

 

or try should give you same result

 

Set Date 2015 = CALCULATE(COUNTROWS('Meters Sold vs Set'), 'Date Dimension'[Year] = 2015)

 

AndrewDang's avatar
AndrewDang
Helper IV
10 years ago

Thanks Sean for your help on this.

 

I had changed the formular.  However, I seam to have two identical lines. In other words, the fomular does not seem to alter my result.  Would you please take anther look at the screen below.

 

here is my fomular: Set Date 2015 = CALCULATE(COUNTA('Meters Sold vs Set'[Set Date]), 'DateKey'[Year] = 2015)

 

 

Thanks Sean