cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
brirack
New Member

Create a measure for count of values by month - and then show all dates in a visualisation

Hi, I have a date table with Jan - June 2021. then another table with row of employee no and a column of corresponding month. I can filter by month and show the different employee count, my question is - how do I create a new visualisation with count of employee for each month that ignores the month filter? Is there a simple measure for this? thanks 🙂

2 ACCEPTED SOLUTIONS
nvprasad
Solution Specialist
Solution Specialist

Hi,

 

You have two options.

1. Use the below DAX function.

     

IngoreMonth = CALCULATE([EmployeeCount],REMOVEFILTERS('Date'))
 

2. Stop Edit interaction with the second visual with month slicer ( Select month slicer then go to format tab click on edit interaction then click on the circle icon above. the second visual)

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

 

View solution in original post

daxer-almighty
Solution Sage
Solution Sage

You don't need a measure for this. It's enough if you just edit the interactions between your visuals. Click the visual, go to the Format tab and then to the Edit Interactions button. On the other visual make it look like this:

daxeralmighty_0-1626546832622.png

 

View solution in original post

2 REPLIES 2
daxer-almighty
Solution Sage
Solution Sage

You don't need a measure for this. It's enough if you just edit the interactions between your visuals. Click the visual, go to the Format tab and then to the Edit Interactions button. On the other visual make it look like this:

daxeralmighty_0-1626546832622.png

 

View solution in original post

nvprasad
Solution Specialist
Solution Specialist

Hi,

 

You have two options.

1. Use the below DAX function.

     

IngoreMonth = CALCULATE([EmployeeCount],REMOVEFILTERS('Date'))
 

2. Stop Edit interaction with the second visual with month slicer ( Select month slicer then go to format tab click on edit interaction then click on the circle icon above. the second visual)

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!