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 ...
  • 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

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