adding counts to slicer

Question

Hi again guru's.&nbsp;I have been asked to update a power BI dashboard to add a count to a slicer.&nbsp;What I have at the moment is a standard slicer (See pic1 below ) - a slicer with a number of categories.&nbsp;What I would like to have is the same but with counts on each slicer.&nbsp; Is this even possisble?I can create a card so when I click on one of the caterory boxs above, the card shows the count - but I would like to have that count in the category slicer.&nbsp;Something like the below example&nbsp;

amitchandak · Answer

Anonymous , seem like you need Dynamic segmentation.
&nbsp;
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

padycosmos · Answer

Hope this helps:https://tutorialslink.com/Articles/How-to-show-count-of-item-on-Slicer-Deep-Dive-Into-PowerBi/1724#:~:text=To%20show%20the%20count%20of,a%20combination%20of%20DAX%20function.&nbsp;

anonymous · Answer

Hi both, sorry for the delayed response.The above has done what I wanted but now I am after an additional piece of help.&nbsp;I created a new table and used that as the slicer - it works in that it gives the sum / count of the attributes,However, when I click on a different attribute to slice / filter my visuals, this total remains static (as I assume it is a calculation based on the raw data only).&nbsp;Is there a way to make this calculation dynamic?&nbsp;Code of current table counter I created...Open_Items_counter_items&nbsp;=SUMMARIZE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;Table1,&nbsp;&nbsp;&nbsp;&nbsp;Table1[Category],&nbsp;&nbsp;&nbsp;&nbsp;"_CategoryCount",&nbsp;COUNT&nbsp;(&nbsp;Table1[Category]&nbsp;)&nbsp;+&nbsp;COUNTBLANK&nbsp;(&nbsp;Table1[Category]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;"_Category_count",&nbsp;SUM&nbsp;(&nbsp;Table1[Counts]&nbsp;)&nbsp;-&nbsp;SUM&nbsp;(&nbsp;Table1[&lt;1Year]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;"_CategoryNameCount",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ISBLANK&nbsp;(&nbsp;VALUES&nbsp;(&nbsp;Table1[Category]&nbsp;)&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Blank()",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VALUES&nbsp;(&nbsp;Table1[Category]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&amp;&nbsp;"&nbsp;("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&nbsp;COUNT&nbsp;(&nbsp;Table1[Category]&nbsp;)&nbsp;+&nbsp;COUNTBLANK&nbsp;(&nbsp;Table1[Category]&nbsp;)&nbsp;&amp;&nbsp;")"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;"_CategoryNameCount2",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ISBLANK&nbsp;(&nbsp;VALUES&nbsp;(&nbsp;Table1[Category]&nbsp;)&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Blank()",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VALUES&nbsp;(&nbsp;Table1[Category]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&amp;&nbsp;"&nbsp;("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&nbsp;SUM&nbsp;(&nbsp;Table1[Counts]&nbsp;)&nbsp;-&nbsp;SUM&nbsp;(&nbsp;Table1[&lt;1Year]&nbsp;)&nbsp;&amp;&nbsp;")"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;))&nbsp;&nbsp;

Forum Discussion

adding counts to slicer

3 Replies

Related content

Adding Counts to Slicer

Counting nulls

Help with matrices slicers, filters and dynamic counts

Adding columns

Count Of Drivers