Forum Discussion

emrei's avatar
emrei
Helper I
2 years ago

PowerBI allocation model trough slicers

I have two tables in Power BI that I've combined, and I'm working on developing a dynamic allocation model. The goal is to use slicers or filters in Power BI to manually adjust the percentage a...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi emrei ,

I create two tables as you mentioned.

Then I create a measure and here is the DAX code.

Spend = SUM(T1[Allocations])*SUM(T1[Supplier Price($)])*SUM(T2[Forecasted Amount(KG)])

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

emrei's avatar
emrei
Helper I
2 years ago

Thanks Yilong, but this is not exactly what I am looking for. Maybe I didn't do a good job with explaining the question. The allocatins column on the table is for reference only. However I want to determine the % on the powerbi report itself. Is there a way that I can use a slicer or something else to assign the allocations and explore various scenarios instead of giving an input table

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi emrei ,

    Sorry, maybe I didn't understand you at first. According to your explanation, Allocations are the columns you want to get in Power BI, but I looked at your table carefully and I don't see any relationship between them and other table data. Can you give me more details about the logic of it?

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.