Table indicator

[Syndicate_Admin]

Good afternoon;

Comundidad I have a question about whether I can create a table with an example identifier 1 to 10

I want that when filtering a CPU product by ejem I need it not to start in 9 and 10 if not from 1 and 2 so for the case of monitor that always starts at 1 and that shows that the amount of data I have.

It is possible to do this.

example:

[Syndicate_Admin]

Thanks for the information

[v-luwang-msft · Accepted solution]

Hi @Syndicate_Admin ，

Base data:

Output result:

Refer the below steps:

create a new column on base table:

Count = COUNTx(FILTER('Table','Table'[Product]=EARLIER('Table'[Product])),'Table'[ID])

Then add a index table:

indextable = DISTINCT('Table'[ID])

Base on this ,create a new table:

Table 2 = DISTINCT(CROSSJOIN(SELECTCOLUMNS('Table',"Product",'Table'[Product],"count",'Table'[Count]),indextable))

Then create a measure ,and use the measure to filter table:

test = IF(MAX('Table 2'[ID])>MAX('Table 2'[count]),BLANK(),1)

Final create visual:

Best Regards

Lucien