Help Required - DAX formula help

[Anonymous]

I need to find percentage error which is Absolute BIAS * 100 / Sales but this i have to filter for each Material number month wise and I hvae to find the same for all Divisions month wise and a combination that includes Total of all divisions in one value. Please what to do ?

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[v-piga-msft]

Hi @Anonymous ,

More details will be much helpful.

I still have a little confused about your requirement.

If it is convenient, could you share some data sample and your desired output so that we could help further on it?

Best  Regards,

Cherry