Forum Discussion

Danielktn's avatar
Danielktn
Frequent Visitor
6 years ago
Solved

Add an ittem to the current filter

Hi,  I have a report where I filter for a month all the financial info for example may comparing it with the previous year.   I want to make a bridge graphic between current year and the pre...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Danielktn ,

     

    Please check:

     

    1. Enter data.

    DataTypeWithDIC:

     

    2. Sort column.

     

    3. Create a measure.

    Measure =
SWITCH (
    MAX ( DataTypeWithDIC[Data Type With DIC] ),
    "R19", CALCULATE ( SUM ( Tabla1[k€] ), Tabla1[Data Type] = "R19" ),
    "R20", CALCULATE ( SUM ( Tabla1[k€] ), Tabla1[Data Type] = "R20" ),
    "DIC19", CALCULATE (
        SUM ( Tabla1[k€] ),
        FILTER (
            ALLEXCEPT ( Tabla1, Tabla1[Concepto] ),
            Tabla1[Data Type with dec] = "DIC19"
        )
    )
)

     

    4. Create visual.

     

    5. Test.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi Danielktn ,

 

Please check:

 

1. Enter data.

DataTypeWithDIC:

 

2. Sort column.

 

3. Create a measure.

Measure =
SWITCH (
    MAX ( DataTypeWithDIC[Data Type With DIC] ),
    "R19", CALCULATE ( SUM ( Tabla1[k€] ), Tabla1[Data Type] = "R19" ),
    "R20", CALCULATE ( SUM ( Tabla1[k€] ), Tabla1[Data Type] = "R20" ),
    "DIC19", CALCULATE (
        SUM ( Tabla1[k€] ),
        FILTER (
            ALLEXCEPT ( Tabla1, Tabla1[Concepto] ),
            Tabla1[Data Type with dec] = "DIC19"
        )
    )
)

 

4. Create visual.

 

5. Test.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Danielktn's avatar
    Danielktn
    Frequent Visitor
    6 years ago

    Thanks it works perfect!