Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 s...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    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?

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

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?

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    MFelix
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous ,

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        MFelix
        Icon for Super User rankSuper User
        6 years ago

        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?