Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I am trying to analyse a data set, below is the sample data
is it possible to get the count of a particular item ( slicer) and the total count of all the items for the order #?
What I am trying is to do is to add "Item" as slicer and I need to get the Count of selected item and the Total count of all the items in an Order #
for example if I add "Wire" in the slider the table should display the Count of selected Item as "1" and I need a measure to display the total count as "5" for the Order # as below
How do I create a measure to exclude the filter and show the Total count of all the items of an Order #
Kindly help to resolve this,
Regards,
Shyam.
Solved! Go to Solution.
Try:
Total count of items = CALCULATE (COUNT(Table[Item]), ALL(Table[Item]))
Proud to be a Super User!
Paul on Linkedin.
Hi @Skumaran
You didn't close your Count() function correctly.
CALCULATE(COUNT(Sheet3[Item]),ALL(Sheet3[Item]))
Hope it helps!
Kind regards,
OD
Hi, It works!!
Thank you very much!!
Try:
Total count of items = CALCULATE (COUNT(Table[Item]), ALL(Table[Item]))
Proud to be a Super User!
Paul on Linkedin.
Hi Paul,
Thank you for your response,
I tried as you suggested but it returned with an error,
Hi @Skumaran
You didn't close your Count() function correctly.
CALCULATE(COUNT(Sheet3[Item]),ALL(Sheet3[Item]))
Hope it helps!
Kind regards,
OD
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
67 | |
60 | |
51 | |
36 | |
36 |
User | Count |
---|---|
83 | |
72 | |
58 | |
45 | |
44 |