How to make combined ABC from 5 tables?

[Anonymous]

Hi 

I have 5 tables where I have made ABC calculation for each one separate in a calculated column in each table:

Rank 2020 =

VAR DemandQC2020 = 'QC'[QC 2020]

VAR AlldemandQC2020 = ALL('QC'[QC 2020])

Return

COUNTROWS(

FILTER(

AlldemandQC2020;

'QC'[QC 2020] > DemandQC2020

)

) +1

 

Cumulative =

CALCULATE(

SUM('QC'[QC 2020]);

ALL('QC');

QC[QC 2020]>= EARLIER(QC[QC 2020])

Cumulative% =

QC[Cumulative]/SUM('QC'[QC 2020])

ABC QC =

SWITCH(

TRUE();

QC[Cumulative%] <= 0,7; "A";

QC[Cumulative%] <= 0,9; "B";

"C"

)

)

This will give me ABC for each, but I want to combine alltogether and I have started to working with a new table called New sales total and I have managed to get item(articles) and the combined qty (with help of sum measurement).

I am trying to follow the same logic for the combined column as the induvidual, but things are not turning out correct.

I am looking for guidance in this.

[v-yuta-msft]

@Anonymous ,

I'm not sure what you want to achieve. Could you please share some sample data and clarify more details about your issue?

Regards,

Jimmy Tao

[Anonymous]

@v-yuta-msft 

Here is a link to my file: https://quintusteam-my.sharepoint.com/:u:/p/dln/EaNNu57XcWpPjQqcVJxzqiYBYHU2kLP9lnqixi6G2miOWg?e=n3k...

Hope it works.

regards

David