Forum Discussion

binayjethwa's avatar
binayjethwa
Icon for Helper V rankHelper V
3 years ago
Solved

Count rows based on slicer

Hi ,    I have the following table where I have list of  Item. To calculate weight , i need to count rows of table which is 14 and divide it by 100 as mentioned below. Also I have a slicer for BL...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi binayjethwa ,

    Actually, there are 14 rows in the table. And 3 duplicated rows not display in the visual, it is by design. You can open my pbix file(the attachment) for the details...

    If you also want to display these duplicated rows in the visual, you can add one index column in Power Query Editor. Please find the details in the updated attachment.

     Add index column

    Toggle off "Text wrap" option

    Best Regards

binayjethwa's avatar
binayjethwa
Icon for Helper V rankHelper V
3 years ago

Hi Anonymous  in the screenshot you shared i see there are 11 rows , hence weight should be 100/11 = 9.09 and not 7.41.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi binayjethwa ,

Actually, there are 14 rows in the table. And 3 duplicated rows not display in the visual, it is by design. You can open my pbix file(the attachment) for the details...

If you also want to display these duplicated rows in the visual, you can add one index column in Power Query Editor. Please find the details in the updated attachment.

 Add index column

Toggle off "Text wrap" option

Best Regards