Forum Discussion

sirbaklava's avatar
sirbaklava
Regular Visitor
2 years ago
Solved

Comparing Data Across Two Filters in Power BI

Hello Power BI Community,   I'm working on a project where I need to compare data across two different filters at a time. My dataset includes two key columns: Site and Item Name. The goal is to cre...
Need Help
  • mickey64's avatar
    mickey64
    2 years ago

    How about this table?

    I also set the filter.

    When using the 'SELECTEDVALUE' function, I think the data column you set for the slicer should be different from the base data column.

mickey64's avatar
mickey64
Super User
2 years ago

For youre reference.

 

Step 0: I use your data below.

 

Step 1: I make 2 tables below.

- 'Sel_Item' Table -

- 'Sel_Site' Table -

 

Step 2: I make 2 slicers, 2 cards, 2 mesures and a table.

IsInBaselineSite =
VAR SelectedBaselineSite = SELECTEDVALUE('Sel_Site'[Site])
VAR CurrentItem = SELECTEDVALUE('Sel_Item'[Item])
RETURN
IF(
COUNTROWS(
FILTER(
ALL(sample_data),
sample_data[site] = SelectedBaselineSite &&
sample_data[item] = CurrentItem
)
) > 0,
"Yes",
"No"
)
 
IsInComparisonSite =
VAR SelectedComparisonSite = SELECTEDVALUE('Sel_Site'[Site])
VAR CurrentItem = SELECTEDVALUE('Sel_Item'[Item])
RETURN
IF(
COUNTROWS(
FILTER(
ALL(sample_data),
sample_data[site] = SelectedComparisonSite &&
sample_data[item] = CurrentItem
)
) > 0,
"Yes",
"No"
)

- 'Site' Slicer-

- 'Item' Slicer -

- Card 1 -

- Card 2 -

- Table -

 

sirbaklava's avatar
sirbaklava
Regular Visitor
2 years ago

Micky thank you so much for replying to my topic.

I see that you created 2 new tables using summarize. I'm having trouble understanding how to apply this to my exact issue. Picture shown below as to what I'm really looking for:

 

my goal is to have the tables show the items within each site. and then a measure just saying if the item is included in the other selected comparison site.

  • mickey64's avatar
    mickey64
    Super User
    2 years ago

    How about this table?

    I also set the filter.

    When using the 'SELECTEDVALUE' function, I think the data column you set for the slicer should be different from the base data column.