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

Farwest's avatar
Farwest
Frequent Visitor
6 years ago

Thanks amitchandak 

 

This actually works better, but I still have a problem.

 

IF(HASONEFILTER('Table' [Name]);
SWITCH(SELECTEDVALUE('Table' [Name]);
"Selected"; MAXX('Table' [Name 1]);
MAXX('Table' [Name 2])
);
MAXX('Table' [Name 2])
)

 

This works when I define the selected Filter Value "Selected", but I am trying  to:

if only one filter is selected then get 'Table' [Name 1] otherwise (all selected) get 'Table' [Name 2]  (this is a single filter selection anyway)