Forum Discussion

Ley's avatar
Ley
Icon for Helper I rankHelper I
6 years ago

selective filter in a measure

Hi, I have a distinctcount measure (total tickets).  This measure should not been filtered by table "incidencias_similares". I can not configurate this exception in " visuals interactions", and sho...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

The information you have provided is not making the problem clear to me. Can you please explain with an example.

  • Ley's avatar
    Ley
    Icon for Helper I rankHelper I
    6 years ago
     

    I show an example,

    As you can see Total incidencias Total tickets= CALCULATE(DISTINCTCOUNT(Data[Ticket ID]);ALL('Incidencias_similares'))

    is not afected by filter, but it is not filtered by Patron

     

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      6 years ago

      Ley 

      Is Patron part of data?

      Try

      CALCULATE(DISTINCTCOUNT(Data[Ticket ID]);ALLSELECTED('Incidencias_similares'))

       

      CALCULATE(DISTINCTCOUNT(Data[Ticket ID]);ALL('Incidencias_similares'[Total Incidences]))

       

      if you need more help make me @

      Appreciate your Kudos.

    • PietroFarias's avatar
      PietroFarias
      Icon for Resolver II rankResolver II
      6 years ago

      This 'Incidencias_similares' table refers to what in that data? Because, as you are applying an ALL, I believe it is directly linked to 'Patron'.

      • Ley's avatar
        Ley
        Icon for Helper I rankHelper I
        6 years ago

        Incidencias_similares is a table that is used to create two filter (in the top of the image). Total tickets should not been filtered by Incidencias_similares.

        Nevertheless, this measure should be filtered by [Patron] and [causa] columns from another table, "Data" table.