Forum Discussion

binayjethwa's avatar
binayjethwa
Helper 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