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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi binayjethwa ，

I created a sample pbix file(see the attachment), please check if that is what you want. You can create a measure as below to get it:

Weight = 
VAR _value = 100
VAR _count =
    CALCULATE ( COUNT ( 'Table'[Item] ), ALLSELECTED ( 'Table' ) )
RETURN
    _value / _count

Best Regards

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

  • binayjethwa's avatar
    binayjethwa
    Helper V
    3 years ago

    Anonymous  This is working as Expected. Thank you