Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multiplying Values By Existing Table for Allocation

I'm trying to back into how many dollars were allocated on eac of these perameteres. For example, I'd like to spit out a DAX measure that will take RA-207's $236,000, from another table [Table 1], and multiply it be each allocation percent for "Allocation Type" D and each utility in [Table 2]. There are other allocation types, not just D in my [Table 2]. I'm not sure which DAX formula to perhaps use to accomplish this caclualtion?

 

The end result would be

$172,280K Common D

$63,270K Common D

 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous,

    Did MFelix 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements to find it more quickly.

    If these also not help, please share more detailed information to help us clarify your scenario to test.

    How to Get Your Question Answered Quickly 

    Regards,

    Xiaoxin Sheng

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    HI Anonymous ,

     

    For this you need to use a measure that picks up the values however this depends on your model.

     

    I have made a simple model with 3 tables:

    Allocation

    Allocation Values (the one with the totals per RA)

    RA table (unique RA values)

     

    Made the relationships has below:

     

    Then added the following measure:

    Total alocated = 
VAR temp_table =
    ADDCOLUMNS (
        SUMMARIZE ( 'Allocations', RA[RA],  'Allocations'[Value] ),
        "@Allocation_Percentage", CALCULATE ( SELECTEDVALUE ( 'Allocation Values'[Total] )
    ))
RETURN
    SUMX (temp_table, Allocations[Value]  * [@Allocation_Percentage] )

     

     

    Only question I have is regarding the part where you refer that there are other type of allocations, you need to add another dimension table with the allocations and related with your model and then add it to the summarize.

     

    Chekc PBIX file attach.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous,

    Did MFelix 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements to find it more quickly.

    If these also not help, please share more detailed information to help us clarify your scenario to test.

    How to Get Your Question Answered Quickly 

    Regards,

    Xiaoxin Sheng