Hi, how to calculate the sales coverage by month in DAX ? Act divided by SFDC ..

[engyin2]

[MFelix · Accepted solution]

Hi @engyin2,

Add a measure with the following syntax:

Average Coverage = DIVIDE ( SUM(Table[Actuals]), SUM(Table[SFDC]))

Then format as percentage.

Regards,

MFelix

[MFelix · Accepted solution]

Hi @engyin2,

Add a measure with the following syntax:

Average Coverage = DIVIDE ( SUM(Table[Actuals]), SUM(Table[SFDC]))

Then format as percentage.

Regards,

MFelix

[engyin2]

Hi MFelix,

Thanks for your advise.

I have changed the formula according to your suggestion and change the value of the coverage to 'average'. However, the % for all three month and total is the same, all showing 128.89%.

How to make the BI understand, the result is Jan (156.89 divided by 77.7M = 204%) and Feb (95.11M divided by 28.99M=328%) and etc.  Thanks

[v-chuncz-msft · Accepted solution]

@engyin2,

Make sure it is a measure, not calculated column.

[engyin2]

Thanks!  It works well now !  \O/