Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I have a table in DAX, not actual but virtual, created using summarize.
I want create a measure and filter the measure using a parameter table (given below).
Is it possible to achieve what i want?
Parameter Table
Slab | Min | Max |
<30K | - | 30,000 |
30K-50K | 30,000 | 50,000 |
>50K | 50,000 | 1,000,000 |
Summarized Table
Account No. | Salary Amount |
9001 | 125,000 |
9002 | 35,000 |
9003 | 28,000 |
9004 | 92,000 |
Hi,
As per our understanding, you are looking for a way to filter your Summarize table with Parameter Table.
You can Achieve this by Below Few steps,
Create a Calculated Column using the below Dax Expression,
Result =
var salary =
'Summarized Table'[Salary Amount]
var range_30k =
IF(salary<30000,"<30K",BLANK())
var range30_50k =
IF(salary>30000 &&
salary<50000,"30K-50K",BLANK())
var range_50k =
IF(salary>50000 &&
salary<100000,">50K",BLANK())
var range_100K =
IF(salary>100000,"<100K",BLANK())
var resultDAX =
IF(range_30k <>
BLANK(),range_30k,
if(range30_50k<>BLANK(),range30_50k,
IF(range_50k<>BLANK(),range_50k,
IF(range_100K<>BLANK(),range_100K))))
return resultDAX
You can use this result column for filtering. Though you are looking to filter with the parameter Table, for this Create a new relationship between both similar columns in the tables,
Then Use Visuals for Filtering the Summarize table,
Thanks!
Inogic Professional Service Division
An expert technical extension for your techno-functional business needs
Power Platform/Dynamics 365 CRM
Drop an email at crm@inogic.com
Service: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |