Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Column 1 | Column 2 | Flag |
A | B | 1 |
B | C | 1 |
D | A | 1 |
E | D | 1 |
I have a table like this. I am able to filter the table by both the columns using a measure. For example, the output table for a filter on both columns 1 and 2 for 'B' looks like this
Column 1 | Column 2 | Flag |
A | B | 1 |
B | C | 1 |
I want a visual that displays only Column 1 and Flag in a Matrix form. The visual I get at the moment
Column 1 | Flag |
B | 1 |
However, I want my visual to look like below
Column 1 | Flag |
A | 1 |
B | 1 |
Can somebody please help?
Solved! Go to Solution.
Assuming you have a Disconnected Table with values in both Column 1 and Column 2. If you have that already, good, other wise, you can create that like with a New Calculated Table like this:
Add the column from your disconnected slicer to the Filters Pane.
Then create a Measure for your flag as below
FlagDisplay =
CALCULATE (
SUM ( 'MyTable'[Flag] ),
KEEPFILTERS (
'MyTable'[Column1]
IN VALUES ( CombinedValues[Slice] )
|| 'MyTable'[Column2] IN VALUES ( CombinedValues[Slice] )
)
)
If this works for you, please mark it as a solution so it can be found easily by anyone who may have similar issues.
Assuming you have a Disconnected Table with values in both Column 1 and Column 2. If you have that already, good, other wise, you can create that like with a New Calculated Table like this:
Add the column from your disconnected slicer to the Filters Pane.
Then create a Measure for your flag as below
FlagDisplay =
CALCULATE (
SUM ( 'MyTable'[Flag] ),
KEEPFILTERS (
'MyTable'[Column1]
IN VALUES ( CombinedValues[Slice] )
|| 'MyTable'[Column2] IN VALUES ( CombinedValues[Slice] )
)
)
If this works for you, please mark it as a solution so it can be found easily by anyone who may have similar issues.
It works, thank you
Hi,
In this case I suggest you use a calculated column with the following formula:
that's what I have in the 2nd table. I want a visual table that doesn't include Column 2 but still gives me all rows filtered in Column 1
Yes, please try to follow my suggestion and don't add the second column, it will work 😊
yes but this is dynamic, I want it to filter based on a Slicer
Is "flag" a numeric column?
yes
How many slicers do you have ?and what are all the columns you are using?
Thanks,
Arul
just one slicer which has combined values of both column 1 and column 2.
User | Count |
---|---|
94 | |
92 | |
84 | |
83 | |
49 |
User | Count |
---|---|
150 | |
146 | |
112 | |
73 | |
56 |