Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Data looks like this:
DispatchID Commodity
12345 top
12345 case
12345 bottom
12345 side
9876 top
9876 bottom
9876 arm
I want to filter out bottom and side, so that it looks like this:
DispatchID Commodity
12345 top|case
9876 top|arm
Current formula that is listing all parts (too many):
Solved! Go to Solution.
@sfsamperi13 , you may try such a measure
All Part List =
CONCATENATEX (
FILTER (
VALUES ( 'FMP Export'[Commodity] ),
NOT ( 'FMP Export'[Commodity] IN { "bottom", "side" } )
),
'FMP Export'[Commodity],
" | "
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
@sfsamperi13 , Create a measure like
concatenatex ( filter ( 'FMP Export', NOT( 'FMP Export'[Commodity] IN { "bottom", "side" } )),'FMP Export'[Commodity]," | ")
@sfsamperi13 , you may try such a measure
All Part List =
CONCATENATEX (
FILTER (
VALUES ( 'FMP Export'[Commodity] ),
NOT ( 'FMP Export'[Commodity] IN { "bottom", "side" } )
),
'FMP Export'[Commodity],
" | "
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
86 | |
67 | |
49 |
User | Count |
---|---|
134 | |
113 | |
100 | |
68 | |
67 |