Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi team,
I have been trying to solve the below but for some reason, I cannot find a way...any help would be of great help. Attached is a sample workbook for reference. The workbook has the following, the first table has products with a combination of products, these are combinations that are not allowed when a new product is requested.
Table 1:
Product 1 | Product 2 |
ABC | DEF |
ABC | GHI |
ABC | JKL |
DEF | ZYX |
DEF | MNO |
ZYX | ABC |
ZYX | JKL |
ZYX | DEF |
The 2nd table includes sales person and their products for which they are responsible to sell.
Table 2:
Sales Person | Products |
John Doe | DEF |
John Doe | GHI |
John Doe | MNO |
There would be a form where a sales rep can request a new product to be included in his / her catalog, The check that is required to be perform is to verify if the products already in the catalog i.e., table 2 and the newly requested is a combination that is not part of the combination in table 1. If the product requested is a combination from table 1 after looking in to the existing values, then it should be denied else output should be granted.
Following is a sample of the table with output.
Input by user(s) | Output | |
Requestor | Requested Product | |
John Doe | ABC | Denied |
The output result is denied as the requested Product ABC with combination DEF which is already part of the user catalog in table 2 is not a valid combination. Any suggestion, help will be of great help here.
Regards,
A!
https://1drv.ms/u/s!Aj7kf6Fnqc5SyTIwwHjuCtcHIRJT?e=XT7LtZ
Solved! Go to Solution.
Hi, @Anonymous , you might want to try this solution (attached file)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi @CNENFRNL ,
Thank you for having this resolved for me. The output of the results are as expected and it works like a charm. The only thing that I have as an issue is that the list for me is exhaustive for each product with more than 80 + combinations and the results take approximately 2 minutes to list down values. Having said this, for now this should help.
Thanks a ton.
Regards,
A!
Hi, @Anonymous , you might want to try this solution (attached file)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
61 | |
18 | |
16 | |
13 |