Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Using filter pane for more than 1 column

Hello, 

 

I have the following table with 2 columns ID and Age. I want to create a table visualization as shown below

In this visulization i want to use the same column Age two times, where the 1st time it will show the range 1-14 age and the second 15-30 age. I was able to do this with the help of measures.
This is the measure i used :

0-14 days =
VAR AGE = 'sample'[AGE]
VAR CALC = IF(AND(AGE >= 0 , AGE<=14), 1, 0)
RETURN
IF(CALC = 1,COUNTA('sample'[ID]))
 

I was wondering if this was possible with the filter pane. The filter pane when used, filters get applied to all instances of the same column. Is there a way to apply the filter to only one instance? Please help!

 

Need Help