Forum Discussion

WTAS80486's avatar
WTAS80486
Icon for Helper IV rankHelper IV
3 years ago
Solved

filter table below based on DAX measure

I have a table on a report with columns ID, site, GM. Two graphs on the same page which should show clustered bar graph with total count of ID without GM by different sites and total count of ID with...
  • Anonymous's avatar
    Anonymous
    3 years ago

    HI WTAS80486,

    I'd like to suggest you write a measure formula with conditions to compare with current row count and return flag.
    After these steps, you can use this on the visual level filter to filter records based selections.

    Applying a measure filter in Power BI - SQLBI

    If you are confused about coding formula, can you please share some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI WTAS80486,

I'd like to suggest you write a measure formula with conditions to compare with current row count and return flag.
After these steps, you can use this on the visual level filter to filter records based selections.

Applying a measure filter in Power BI - SQLBI

If you are confused about coding formula, can you please share some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng