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], an...
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

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.