Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

filter a summarize table

Hi all, I am trying to filter my SUMMARIZE table to only where the Contract Status = "Active" in table1   This is my current SUMMARIZE table:   Summarize Table = SUMMARIZE('table1, 'table1'[ID], ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    According to my understanding, you want to filter a summarized table when the Contract Status equals to "Active" , right?

    You could use the following formula:

    Summarize Table =
CALCULATETABLE (
    SUMMARIZE (
        'Table1',
        'Table1'[ID],
        "Profiles", MAX ( 'Table1'[Profiles] ),
        "Additional Storage", SUM ( 'Table1'[Additional Storage] )
    ),
    'Table1'[Contract Status ] = "Active"
)

    My visualization looks like this:

    Is the result what you want? If not, please upload some data samples and expected output.

    Please do mask sensitive data before uploading.

     

    Best Regards,

    Eyelyn Qin

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

According to my understanding, you want to filter a summarized table when the Contract Status equals to "Active" , right?

You could use the following formula:

Summarize Table =
CALCULATETABLE (
    SUMMARIZE (
        'Table1',
        'Table1'[ID],
        "Profiles", MAX ( 'Table1'[Profiles] ),
        "Additional Storage", SUM ( 'Table1'[Additional Storage] )
    ),
    'Table1'[Contract Status ] = "Active"
)

My visualization looks like this:

Is the result what you want? If not, please upload some data samples and expected output.

Please do mask sensitive data before uploading.

 

Best Regards,

Eyelyn Qin