Forum Discussion

Farwest's avatar
Farwest
Frequent Visitor
6 years ago
Solved

Column selection based on Filter

Dear Power BI community,   I am having a hard time setting a dynamic filter on a report.   I am trying to use a filter in order to set a measure, it is a single selection filter.   Selected = i...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Farwest ,

    Please try to complete the following steps to achieve your requirement:

    1. Create one dimension table for name field(Group 1,Group 2,Group 3 etc. )

    Create table Groups

    2. Create the relationship between two tables using field "Group" in Groups table and "Name" field in Table

    Create relationship between dimension and fact table

    3. Create a measure and drag the related fields onto the visual as below screen shot

    Measure = IF(ISFILTERED('Groups'[Group]),MAX('Table'[Name 2]),MAX('Table'[Name 1]))

    Create measure and table visual

    Best Regards

    Rena

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Even i'm having a similar requirement ..

 

Whenver user select single value from slicer in a dynamic table then we should filter out null records but whenever use select more than 1 column then display all values in every columns (no need to filter out.) Any idea how to achieve this ?