Total Revenue divided by count of months for each ID

[cherrypbi]

Hello,

I'm trying to create a DAX formula that follows below table. Is this something that can be achieved by DAX? 

any help would be appreciated! 

[v-jingzhang · Accepted solution]

Hi @cherrypbi 

Yes, you can create a measure with below DAX formula and put it into a visual along with the ID column. 

Total Revenue = DIVIDE(SUM('Table'[Revenue]),COUNT('Table'[Month])) * 12

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.