Forum Discussion
Table/Matrix Contents Change Based on Slicer Selection
Hello,
Thank you for your response, based off of your summary, you understand what I am trying to accomplish. Below is a photo of how the data is coming into PBI. Can you apply this same DAX logic with the layout of the data shown below? if so, how would you write it?
We do not have a "Meeting Status" column because of the layout of the data.
Hi,
I am out of city therefore replay is late.
I understand that you don't have a specific "Meeting Status" column in your data, but you want to filter the data based on the layout provided. In this case, you can still achieve the desired result by creating a calculated column that generates the meeting status based on the existing columns in your dataset.
Assuming you have a table structure similar to the one shown below:
| Individual | Meeting 1 | Meeting 2 | Meeting 3 | ... |
|------------|-----------|-----------|-----------|-----|
| Person A | X | | | |
| Person B | | X | | |
| Person C | N/A | N/A | X | |
| ... | ... | ... | ... | ... |
You can create a calculated column to determine the meeting status for each individual. You can use a formula like this:
MeetingStatus =
IF([Meeting 1] = "X" || [Meeting 2] = "X" || [Meeting 3] = "X", "X", "")
This formula checks each meeting column for "X" attendance and assigns "X" to the calculated column if any of the meetings has "X" attendance; otherwise, it assigns an empty string ("") for "N/A" or non-attended meetings.
After creating the "MeetingStatus" calculated column, you can proceed with the steps mentioned in my previous response to filter your data based on the slicer selection, using the FilteredData measure. The measure would remain the same as previously described:
FilteredData = FILTER(YourTableName, YourTableName[MeetingStatus] IN {"X", ""})
Replot YourTableName with the actual name of your table.
With this approach, you can dynamically filter the data to show only "X" and "" for individuals based on the slicer selection, even without a dedicated "Meeting Status" column in your original data.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.