Count by Dimensions

[reporting_neu]

Hello,

I have a KPI and I want to count the number of parts.

Example:
There are 100 pieces. But if I add the validity (valid from), there are already 300 versions. If I add the part list, there are 900 versions.

How can I count this in a KPI?

[Rohan]

Hi,

Kindly elaborate the scenario with some mock data.

Regards,

Rohan.

[reporting_neu]

Mock data:

Partlist	Part	ValidFrom	PartType	SalesList
100	1222	01.01.2023	X1	100100
100	1222	01.02.2023	X3.3	100100
100	1224	01.01.2023	X1	100101
101	1222	01.01.2023	X2	100100
101	1222	01.02.2023	X3.3	100100
101	1222	01.01.2023	X1	100200

I want to count the number of parts with dimensions "Partlist", "Part" and "ValidFrom". "PartType" and "SalesList" are unimportant to me.

In total I have 6 versions. But if I only want to count the first three columns or dimensions, I have 5 versions.

If I only want to count the first two colums or dimensions, I have 3 versions.

Do you know what I mean?

[marcus_sommer · Accepted solution]

You may try it with: count(distinct Partlist & Part & ValidFrom)