Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Syndicate_Admin
Administrator
Administrator

Table indicator

Good afternoon;

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

Kalu0311_0-1669836873021.png

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:

Kalu0311_1-1669837026898.png

Kalu0311_2-1669837042068.png

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @Syndicate_Admin ,

Base data:

vluwangmsft_1-1669860762780.png

 

Output result:

vluwangmsft_2-1669860777516.pngvluwangmsft_3-1669860784376.pngvluwangmsft_4-1669860790888.png

 

Refer the below steps:

create a new column on base table:

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

vluwangmsft_5-1669860833321.png

 

Then add a index table:

indextable = DISTINCT('Table'[ID])

vluwangmsft_6-1669860863624.png

 

Base on this ,create a new table:

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

vluwangmsft_7-1669860904805.png

 

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:

vluwangmsft_8-1669860972264.png

 

 

 

Best Regards

Lucien

View solution in original post

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

Thanks for the information

v-luwang-msft
Community Support
Community Support

Hi @Syndicate_Admin ,

Base data:

vluwangmsft_1-1669860762780.png

 

Output result:

vluwangmsft_2-1669860777516.pngvluwangmsft_3-1669860784376.pngvluwangmsft_4-1669860790888.png

 

Refer the below steps:

create a new column on base table:

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

vluwangmsft_5-1669860833321.png

 

Then add a index table:

indextable = DISTINCT('Table'[ID])

vluwangmsft_6-1669860863624.png

 

Base on this ,create a new table:

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

vluwangmsft_7-1669860904805.png

 

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:

vluwangmsft_8-1669860972264.png

 

 

 

Best Regards

Lucien

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.