Forum Discussion
Measurement Filtered only by one slicer
Hi 🙂
I have a table with 3 fields: Ticket ID, Closed Date, Assigned To.
I added 2 slycers: Closed Date and Assigned To.
I would like to create a measurement that only respects Closed Date selection.
I've created like this:
Hi Anonymous ,
Do you have a calendar table as a dimension? Or are you using the slicer from your closed date column?
If you are using a column from your data you may not get the expected result since all your context is overlapping with different context from other interactions on the table.
Is it possible to share a sample?
8 Replies
- amitchandak
Super User
Please refer to my blog on similar lines :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
- MFelix
Hi Anonymous ,
If this measure is to be on a visualization only by itself the best way is to turn off intractions between assign to slicer and the visualization where you place the count.
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Using a measure like you have written should work. What is the context of the visualization you are using? What are you using as axis, filters, legends on your visualization?
Thanks for the reply MFelix
I would like to use this measurement to compare a user closed tickets vs the average of closed tickets for all users.
I'm just showing the measurement value on a simple CARD tile.
Time Frame WI Closed = CALCULATE(COUNTROWS('CRs All Time');ALLEXCEPT('CRs All Time';'CRs All Time'[Closed Date]))- MFelix
Hi Anonymous ,
Being just this the easiest way is to turn off interaction between the slicer and the card visual.
