Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have created a table as below -
The last two columns - Total stock and QN are calculated columns. They are summation of different columns.
I have a requirement to filter these last two columns on different conditions.
"Total stock" needs to be filtered on Storage location =
"QN" needs to be filtered on Storage location =
Storage location is another column in the same table.
I need to diplay this in the same table that I attached. I am trying to automate the work that is done in excel into powerBI. In excel, I could manually choose the necessary filters per column and was able to get the desired table.
I tried checking Filter function but I was not able to get the desired results. Could anyone please help.
Thank you.
Solved! Go to Solution.
New columns
Total Qty = Switch( True() ,
[ Storage location] in {"0010","0020","MDD","MDR"} , [Confirmed Qty],
blank()
)
QN = Switch( True() ,
[ Storage location] in {"ATQN",
"GGQN",
"RQTF",
"AQTF",
"ASEG"}
, [Confirmed Qty],
blank()
)
Thanks it worked. But I had to make a small change as I wanted to see the value of QN columns after filteration.
New columns
Total Qty = Switch( True() ,
[ Storage location] in {"0010","0020","MDD","MDR"} , [Confirmed Qty],
blank()
)
QN = Switch( True() ,
[ Storage location] in {"ATQN",
"GGQN",
"RQTF",
"AQTF",
"ASEG"}
, [Confirmed Qty],
blank()
)
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |