Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have a table that shows payment commissions '(Consult[Commission])' for each product sale '(Consult[serialnumber]', each line shows a payment, however I have codes where more than one type of commission was paid, so in same table I get duplicate product codes for different commissions, however some commissions cannot be paid for the same product, I need a DAX to do this check, I have another table with the name of each type of commission '(Parameters[ commission]) and which commission cannot be paid together '(Parameters[notaccumulate])'
Unfortunately I can't show much, as it is confidential information
For some commissions, there are several that cannot accumulate, so it ended up in this format:
Table: parameters | Table : Consult |
| |||||
comission | Not acumulate | Serial number | Comission | ||||
AA001 | AA002 | AWB2703 | A002 | ||||
AA002 | AA004 | AWB2704 | AA003 | ||||
AA003 | AA005 | AWB2704 | AA005 | ||||
AA003 | AA001 | AWB2706 | |||||
AA003 | AA002 | ||||||
I tried to create an index to classify the same codes with a single number and create a single table, returning whether the code should not have been paid or whether it is ok, but it didn't work,
i tri to summarize and rankx
and that was my last attempt
ElegibilityCheckGeneric = |
and try like this too
PaymentVerificationGeneric = ADDCOLUMNS( SUMMARIZE(GenericTable, GenericTable[GroupingColumn1], GenericTable[GroupingColumn2], GenericTable[DisallowedColumn]), "Result", IF( COUNTROWS( FILTER( ALL(GenericTable), GenericTable[GroupingColumn1] = EARLIER(GenericTable[GroupingColumn1]) && GenericTable[GroupingColumn2] = EARLIER(GenericTable[DisallowedColumn]) ) ) > 0, "Invalid Payment", "OK" ) ) |
Pleasee someone help me...
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
11 |