Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago
Solved

how to create a filter for table visuals

Hello Team,

below is visual table on my dashboard and the values come from 2 tables

Account_Listing: FYTD TER

TMT Master NEW: Market value and sales

Capture.PNG

I would like to create a filter that will allow my users to see the Lates Mareket Vale over $1b and a TER of $100,000 or less

How can I do that?

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi vjnvinod,

    It seems like you want to direct filter based on aggregated values, right?
    If this is a case, I'd like to suggest you write a total measure formula to calculate the aggregate value based on current categories, then use this on the visual level filter with 'between' mode to filter specific amount range.

    Measure total =
VAR summary =
    SUMMARIZE (
        'Table',
        [Category1],
        [Category2],
        [Category3],
        "Total", SUM ( Table[Lates Mareket Vale] )
    )
RETURN
    SUMX ( summary, [Total] )

    Measure Totals, The Final Word 
    Regards,

    Xiaoxin Sheng

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi vjnvinod,

    It seems like you want to direct filter based on aggregated values, right?
    If this is a case, I'd like to suggest you write a total measure formula to calculate the aggregate value based on current categories, then use this on the visual level filter with 'between' mode to filter specific amount range.

    Measure total =
VAR summary =
    SUMMARIZE (
        'Table',
        [Category1],
        [Category2],
        [Category3],
        "Total", SUM ( Table[Lates Mareket Vale] )
    )
RETURN
    SUMX ( summary, [Total] )

    Measure Totals, The Final Word 
    Regards,

    Xiaoxin Sheng