Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Table indicator

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:

  • v-luwang-msft's avatar
    v-luwang-msft
    3 years ago

    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

2 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    3 years ago

    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