how to create a filter for table visuals

[vjnvinod]

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

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?

[v-shex-msft · Accepted solution]

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

[parry2k]

@vjnvinod duplicate post.