cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Keelin Regular Visitor
Regular Visitor

Filter issue

Hi All, I need to be able to use a simple measure with different filters. I cant seem to get it to work

 

The slicer will be CRSLevel so I have used an IF(ISFILTERED statement.

I am tring to filter on a second table. I 

Does anyone know if there is a simple issue with the DAX? I think the relationships between the tables are ok.

 

National Result 3 = IF(
			ISFILTERED('2012-2017 SES National Analysis UA'[CRSLEVEL (groups)]),
            CALCULATE([UA Indicator: Overall Satisfaction Experience],
            FILTER(ALL('Uni Classifications'),
            'Uni Classifications'[Group]="National")
            )
)
 
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Filter issue

Hi @Keelin

I make a test with IF(ISFILTERED statement, when i do not select any in the slicer, the table visual shows blank

Measure =
IF (
    ISFILTERED ( Sheet4[grouplevel] ),
    CALCULATE ( SUM ( Sheet3[col1] ), FILTER ( ALL ( Sheet3 ), [col2] = "n" ) )
)

when i select "1" from slicer, it will show values

9.png

my tables' relationship:

Sheet3   (many to one)   Sheet4

 

Please show me what's wrong on your side so i can reproduce and analyze this.

 

Best Regards

Maggie

2 REPLIES 2
Super User
Super User

Re: Filter issue

Hi,

 

Please share some data and also show the expected result.

Community Support Team
Community Support Team

Re: Filter issue

Hi @Keelin

I make a test with IF(ISFILTERED statement, when i do not select any in the slicer, the table visual shows blank

Measure =
IF (
    ISFILTERED ( Sheet4[grouplevel] ),
    CALCULATE ( SUM ( Sheet3[col1] ), FILTER ( ALL ( Sheet3 ), [col2] = "n" ) )
)

when i select "1" from slicer, it will show values

9.png

my tables' relationship:

Sheet3   (many to one)   Sheet4

 

Please show me what's wrong on your side so i can reproduce and analyze this.

 

Best Regards

Maggie