Help with DAX FORMULAR

[Anonymous]

Hi,in this dashboard i am creating, there a plant material and multiple vendors for each material and i am trying to calculate how much is received from each vendor at any given period selected in the outlook date.  the figure in red is the total received from all vendors of a particular material within the entire period while the one circled in black is the total from all vendors of this particular material with the outlook date i have currently selected. How can i make sum of total Buom to be the same as the sum of BUom for the outlook date selected so that the percentage for each vendors can always sum up to 100% of the receipts in the selected outlook date.

Sum of total BUom was created with this DAX : 

SummarizedTab =

SUMMARIZE(

    csp_act_rpi,

    csp_act_rpi[calendar_day],

    csp_act_rpi[plant],

    csp_act_rpi[MatNr],

    "Total BUom_Act_DistReceipts",

    CALCULATE(

        SUM(csp_act_rpi[BUoM_Act_DistrReceipts]),

        ALLEXCEPT(csp_act_rpi, csp_act_rpi[MatNr], csp_act_rpi[calendar_day])

    )

)

While the dax for the percentage is this : 

Vendor_Percentage1 = DIVIDE(SUM(csp_act_rpi[BUoM_Act_DistrReceipts]),SUM(SummarizedTab[Total BUom_Act_DistReceipts]),1)

[Anonymous]

Hi, 
Thanks a lot for your help with the DAX.
As i have began expanding the scope of the data i am working with, i have met new hurdle that i can't seem to solve.

Regarding item 60630813, I've observed discrepancies in the data received from three suppliers. Specifically, the data originates from two sources: a comprehensive table containing all receipts and various Excel files provided by buyers responsible for specific items.

In an effort to streamline monitoring and allocation of suppliers alongside our receipts, I've developed a dashboard. However, since its creation, I've encountered an issue: suppliers present in our receipts are exclusively those listed in the Excel sheets provided by buyers, and vice versa. Consequently, any supplier not included in the buyer's Excel sheet does not appear in our receipts, and any supplier listed in the Excel sheet from whom we haven't received anything is also absent.

I'm seeking guidance on implementing a DAX (Data Analysis Expressions) solution to address this challenge. Specifically, I aim to create logic whereby any supplier from whom we've received goods but is not listed in the buyer's Excel sheet would be categorized as "Unassigned." Similarly, any supplier listed in the Excel sheet from whom we haven't received any goods would also be labeled as "Unassigned."

It's important to note that in Power BI, I've performed a join between our receipt table and the Excel sheet using the vendor and item number as key identifiers.

I appreciate your insights and assistance in resolving this matter effectively.
This are the three suppliers in my receipts 

below are the three suppliers in my excel sheet

Below is what my dashboard looks like when i am done

From here we can see that one vendor from my receipt is missing in my dashboard because they are not in my excel sheet and one from my excel sheet is missing because i did not receive anything from them

[Anonymous]

zing!!!! Thanks

[Anonymous · Accepted solution]

Hi @Anonymous 

You can create two measures with these DAX:

Total BUom_Act_DistReceipts =
CALCULATE (
    SUM ( csp_act_rpi[BUoM_Act_DistrReceipts] ),
    ALLSELECTED ( csp_act_rpi[N_Vendor] )
)

Vendor_Percentage1 =
DIVIDE (
    SUM ( csp_act_rpi[BUoM_Act_DistrReceipts] ),
    [Total BUom_Act_DistReceipts],
    1
)

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!