Dax Calculation Sum Divide Filter

[colourfullife]

Hi,  I need help!

This is example of my table and there is a steps 1~3 below that i want to make in PBI.

please let me know if you have any ideas. Many thanks in advanced.

Item	Issue Qty	Storage Qty	Actaul Rev	Level	Warehouse
A	0	1	1	INV	W
B	0	0	1	INV	W
C	0	0	3	INV
D	4	0	1	INV
E	0	0	1	INV
F	0	2	3	ER
G	0	0	5	ER
H	0	0	4	ER	W
I	0	0	4	ER
J	1	0	4	ER
1. Total : Issue Qty + Storage Qty + Actual Rev = 35
2. Want to get a sum of Actual Rev after filter INV in Level colum and filter balnk in warehouse colum = 5
3. Want to get a pecentage of no2/no1 = 5/35*100=14.2%

[sturlaws · Accepted solution]

Hi,

these formulas are pretty simple to create, although they might have to be made more complex depending on how you intend to use them. So when posting questions, it is always a good idea to create a mock-up of how you want your solution to look like, or at least describe it.

pbix-file

cheers,
-s

[colourfullife]

Hi,

This is just perfect. I created one that i want with the dax, exactly what you said.

Thank you very much!

Cheers,

CL