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.
Hi all,
This is driving me crazy. In my calculated table I want to remove the rows which contain a blank. A very simple task but I can't get it working. Any help is appreciated!
I combine to columns and filter out the duplicates. This works fine but the column contains still 1 blank which I want to get rid off. The code looks very simple. As example I tried FILTER which doesn't work.
Solved! Go to Solution.
You can use
Bridge SO =
VAR MNSO =
FILTER (
DISTINCT ( mn_rcpl[ServiceOrderNumber] ),
NOT ISBLANK ( mn_rcpl[ServiceOrderNumber] )
)
VAR PUSO =
FILTER (
DISTINCT ( 'Parts Usage Frequency Report - Raw Data'[Service Order] ),
NOT ISBLANK ( 'Parts Usage Frequency Report - Raw Data'[Service Order] )
)
VAR CombinedSO =
DISTINCT ( UNION ( MNSO, PUSO ) )
RETURN
CombinedSO
Hello @mgils24 ,
The issue likely arises because FILTER expects a table and you're passing a column expression. By wrapping the column in FILTER directly within the RETURN statement, this will resolve the problem
BridgeSO =
VAR MWSO = VALUES(mn_rcp[ServiceOrderNumber])
VAR PUSO = VALUES('Parts Usage frequency report + Raw data'[Service Order])
VAR CombinedSO = UNION(MWSO, PUSO)
VAR CombinedSO2 = DISTINCT(CombinedSO)
RETURN
FILTER(CombinedSO2, NOT(ISBLANK(CombinedSO2)))
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
You can use
Bridge SO =
VAR MNSO =
FILTER (
DISTINCT ( mn_rcpl[ServiceOrderNumber] ),
NOT ISBLANK ( mn_rcpl[ServiceOrderNumber] )
)
VAR PUSO =
FILTER (
DISTINCT ( 'Parts Usage Frequency Report - Raw Data'[Service Order] ),
NOT ISBLANK ( 'Parts Usage Frequency Report - Raw Data'[Service Order] )
)
VAR CombinedSO =
DISTINCT ( UNION ( MNSO, PUSO ) )
RETURN
CombinedSO
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |