Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
v-juanli-msft
Community Support
Community Support

Hi @Anonymous

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

View solution in original post

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

Hi @Anonymous

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

Ashish_Mathur
Super User
Super User

Hi,

 

Please share some data and also show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.