Create a table that has the number of customers on each classification

[ruzanovsky]

Hello!

I want to count the number of customers on each classification and make it appear on that right table. How do I make that?

EX: on AA we have 2 customers on 100%, 1 on 99%~96%, 1 on 96%~90%...

[ruzanovsky]

No ideas? Thats what I want, to show the number of customers that are AA and 100% OTIF

OTIF is a metric, I cant filter out on CALCULATE.

In this case there are 3 customers, I want to show that on a quantitative value.

[ruzanovsky]

How do I attach the pbix here?

[v-jiascu-msft]

Hi @ruzanovsky,

You can upload the file to the cloud drive like OneDrive, GoogleDrive, then share the link here if you can. Or send me a message through Message.

Best Regards,

Dale

[ruzanovsky]

Unfortunately I can't upload anything from inside the company.

Anyways, if you can figure it out let me know!

[ruzanovsky]

Clarifying, I want a DAX that counts number of customers and filters by OTIF % and Classification

This is what I have so far ( in this case I want only 100% OTIFS and .AA classifications ), but that does not work

COUNT .AA 100% = CALCULATE(

IF([OTIF %]=1;

COUNT(Customer[Customer Name]));

CCares[Customer Classification]=".AA")

What am I missing?

[v-jiascu-msft]

Hi @ruzanovsky,

Can you share a sample of the original data? The pbix file would be great.

Best Regards,

Dale