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?

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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks MFelix 

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