Forum

Power BI - formula
 
Notifications
Clear all

Power BI - formula

3 Posts
2 Users
0 Reactions
91 Views
(@filipaalmeida)
Posts: 3
Active Member
Topic starter
 

Hi Mynda,

How I can divide one value (value for one factory) for the sales for all group?
If I use the related function, it will divide only for the sales of this factory.

Which formula I should use to consider all the sales instead only for the one factory?

Thanks in advance

Regards

 
Posted : 03/06/2023 9:26 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Filipa,

It's difficult to be specific without seeing your file, but have you watched lessons 9.06 - 9.08 on the ALL, ALLEXCEPT and ALLSELECTED functions?

I suspect one of these is what you need. If you're still stuck, please share a small file containing a mockup of your data and model that illustrates the issue and desired result so we can help you further.

Mynda

 
Posted : 04/06/2023 1:44 am
(@filipaalmeida)
Posts: 3
Active Member
Topic starter
 

Hi Mynda,

Many many thanks. Now it is working 🙂 I used allselected 🙂

 
Posted : 06/06/2023 12:50 pm
Share: