Forum Discussion

sns1996's avatar
sns1996
Helper I
1 year ago
Solved

Filtrar valor

Estou precisando filtrar da tabela reclamação (Abaixo) montando a tabela abaixo:   Tem como anexar o arquivo pbix   Mês Bravura Agosto Mês Ocorrência Agosto e Mês data banca Agosto Set...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi sns1996 , Arul, thank you for your prompt reply!

    Check the following measure:

     

    ComplaintValue = 
    SWITCH(
        TRUE(),
        MAX('Table'[Month Occurrence]) = "August" ,
            CALCULATE(SUM('Table'[Value]), 
                'Table'[Month Occurrence] = "August" &&
                'Table'[Month Date Bank] = "August"),
        MAX('Table'[Month Occurrence]) = "September" ,
            CALCULATE(SUM('Table'[Value]), 
                'Table'[Month Occurrence] = "September" &&
                'Table'[Month Date Bank] = "August"),
        MAX('Table'[Month Occurrence]) = "October" ,
            CALCULATE(SUM('Table'[Value]), 
                'Table'[Month Occurrence] = "October" &&
                'Table'[Month Date Bank] = "August"),
        BLANK()
    )

    Result for your reference:

    Best regards,

    Joyce

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

Arul's avatar
Arul
Super User
1 year ago

sns1996 ,

Please translate in English.

sns1996's avatar
sns1996
Helper I
1 year ago

I need to filter from the complaint table (Below) by creating the table below:

Can you attach the pbix file?

 

part of the table

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi sns1996 , Arul, thank you for your prompt reply!

    Check the following measure:

     

    ComplaintValue = 
    SWITCH(
        TRUE(),
        MAX('Table'[Month Occurrence]) = "August" ,
            CALCULATE(SUM('Table'[Value]), 
                'Table'[Month Occurrence] = "August" &&
                'Table'[Month Date Bank] = "August"),
        MAX('Table'[Month Occurrence]) = "September" ,
            CALCULATE(SUM('Table'[Value]), 
                'Table'[Month Occurrence] = "September" &&
                'Table'[Month Date Bank] = "August"),
        MAX('Table'[Month Occurrence]) = "October" ,
            CALCULATE(SUM('Table'[Value]), 
                'Table'[Month Occurrence] = "October" &&
                'Table'[Month Date Bank] = "August"),
        BLANK()
    )

    Result for your reference:

    Best regards,

    Joyce

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