Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
gree1502
Helper II
Helper II

Can't create a pie chart using old count of column after using slicer

Hi,

I have a column named "A" which has unique values. And another column "Adate" which has corresponding dates. They are not unique. I am using slicer for representing date, which shows count of "A" column which falls under the start date and end date selected.

I want a pie chart which shows count of A depending on the slicer and also total count of A before applying the slicer.
Eg: If total count is 200. And depending on the slicer, if the count changes to 90. I want a chart which shows 200 and 90.

What will the approach be?

Any help will be appreciated!
Thanks in advance

1 ACCEPTED SOLUTION
Phil_Seamark
Microsoft Employee
Microsoft Employee

Not sure if I have understood this correction but here goes.

 

The following measures can both be added to a single pie visual.  Measure 1 will only show the count of A within your date range, whereas Measure 2 will show the total count regardless.  Like I said, I'm not sure if I have understood this, but lets see where this goes 🙂

 

 

Measure 1 = CALCULATE(COUNT(Table1[A]))

Measure 2 = CALCULATE(COUNT(Table1[A]),all('Table1'[ADate])) 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
Phil_Seamark
Microsoft Employee
Microsoft Employee

Not sure if I have understood this correction but here goes.

 

The following measures can both be added to a single pie visual.  Measure 1 will only show the count of A within your date range, whereas Measure 2 will show the total count regardless.  Like I said, I'm not sure if I have understood this, but lets see where this goes 🙂

 

 

Measure 1 = CALCULATE(COUNT(Table1[A]))

Measure 2 = CALCULATE(COUNT(Table1[A]),all('Table1'[ADate])) 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Thank you so much! It worked:)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors