Forum Discussion
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...
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
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
Anonymous This is working as Expected. Thank you