cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Unable to find way to write Measure for finding list of values available in a table in DAX.

Hi Team,

 

I need a help in writing a Measure using DAX . 

Scenario1: I have a list of values , for which i want to view data in a table visual. I want to place a measure which filters data. I have a thousands of records in the table out of which i need to select a hundreads of records in filter.

Table Example - Customer

Customer _IDCustomer_Name
1001Philips
1002Warner
1003Curran
1004Joseph
1005Steve

 

I need to create a measure so that i can place that measure on visual filter level to see only for records 101 and 102.   

So wanted to check best possible way to write the measure .

Tried Below way but it throws Resource memory exceeded issue.
VAR CSList = MAX(Customer[Customer_ID])
VAR HL = {"I001","I002","I003","I004","I005","I006","I007","I008","I009","I010","I011","I012","I013","I014","I015","I016","I017","I018","I019","I020","I021","I022","I023","I024","I025","I026","I027","I028","I029","I030","I031","I032","I033","I034","I035","I036","I037","I038","I039","I040","I041","I042" }
RETURN
IF((CSList in HL),1,0)

 

Any help is highly appreciated.

1 REPLY 1
Super User II
Super User II

This works fine on my PC.  How much RAM does yours have?

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors