Measurement Filtered only by one slicer

[cardojp5]

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:

CALCULATE(COUNTROWS('CRs All Time');ALLEXCEPT('CRs All Time';'CRs All Time'[Closed Date]))

Somehow something is wrong because the count returned by this is also filtered by Assigned To Slicer selection 😞

Any suggestions ?

[MFelix]

Hi @cardojp5 ,

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?

[cardojp5]

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 @cardojp5 ,

Being just this the easiest way is to turn off interaction between the slicer and the card visual.

[cardojp5]

Thanks @MFelix 

I think i failed to explained myself.

Currently i only have those graphics just to easier investigate the problem that's affecting that measurement. So.. no fancy context, filters or other parameters in the way the measurement is being calculated.

However, i would like to use this measurement as a target field on a gauge chart. I would like to filter by "assigned to" and get the gauge value filteres by the slicer, but then, add this measurement with the average from other users as a target value.

Any hint to move forward with this problem ?

Thanks for your  help.

[MFelix · Accepted solution]

Hi @cardojp5 ,

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?

[cardojp5]

Thanks @MFelix 

I created a dimension table for dates and it solved the issue.

[MFelix]

Hi @cardojp5 ,

Ussually when using dates it's a good practice to use a calendar table to make the interactions.

Glad I could help.

[amitchandak]

Please refer to my blog on similar lines :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...