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!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.