cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nebiroswill
Regular Visitor

dax measure that adds excess filtering values

hello dear, help help,

 

I have not been able to get the result for a week, I need to have a report in which the excess can be calculated for not having sold for each point of sale (increment - sale in units), if we see excess by products selecting a point of sale, we get a total of excesses (so far) and this value I want to show in another table only by point of sale but the measure does not work, I tried to "calculate" and filtered, with "sumx" and filtering or all together but nothing .

 

please help me thank you very much.

 

attached file thank you very much.

 

MeasurePOWER BI.JPG

 

https://www.dropbox.com/s/7kljiwooxxd2qpn/INCREMENTOS%20will.pbix?dl=0

2 REPLIES 2
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @nebiroswill,

 

What is your desired output?

 

Please share your expected output and describe your logic in more details so that I can understand your scenario better and get the solution.

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you very much,

I have to perform an analysis to determine if the increments that are made in products for each point of sale are sold or not sold and get the value of what was not sold in units and in this way know the excess generated by product as well as for each point of sale.

I have three tables: increments, units sold and net sale in which the table increases by "related" I obtain information through a link code the units sold and the net sale.

I believe measures to obtain total increase and units sold:

SUM-IncremUnds = SUM ('public IncrementsTransferencesFairs' [IncrementUnds])

SUM-UndsSellings = SUM ('public IncrementsTransferencesFairs' [UndsDownloads])

The operation to know the excesses is:

UndExces = [SUM-IncremUnds] - [SUM-UndsSoldings] and I apply a visual object level filter because it was impossible for me to exclude the negative values ​​through "Calculate" with a filter and when it is filtered, the measurement does not work because example:

SUM-IncremUnds = 2 (-) SUM-UndsSoldings = 2 --> UndExces = 2 ¿?



In the matrix table "detail by pos" if we select a point of sale the table of products changes the table "Detail by Product" with its respective total, this value of Total desire that is shown in the table "Summary by Point of Sale "However, I have not been able to make the measurement because the increase is adding up.

I have chosen to create measures only for the "Summary by Point of Sale" table and with "Calculate" filter when SUM-IncremUnds> SUM-UndsSold but it does not work either.

 

What am I doing wrong?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.