Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, i need a daxhero!
I need to count Orders with a specific color and without it.
OrderID | Color | Product | Values |
111 | Blue | Prod1 | 1 |
111 | Blue | Prod2 | 2 |
111 | Red | Prod3 | 5 |
111 | Green | Prod1 | 2 |
222 | Red | Prod2 | 4 |
222 | Green | Prod3 | 6 |
333 | Red | Prod1 | 1 |
333 | Red | Prod2 | 2 |
333 | Blue | Prod3 | 5 |
333 | Green | Prod1 | 2 |
For measure with color is easy:
Solved! Go to Solution.
Hi, @mic_rys
Please kindly check the below.
The sample pbix file's link is down below.
Without Blue =
VAR bluetable =
SUMMARIZE (
FILTER (
SUMMARIZE ( 'Table', 'Table'[OrderID], 'Table'[Color] ),
'Table'[Color] = "Blue"
),
'Table'[OrderID]
)
VAR alltable =
VALUES ( 'Table'[OrderID] )
RETURN
COUNTROWS ( EXCEPT ( alltable, bluetable ) )
https://www.dropbox.com/s/jw8dfslfo4zte4j/mic%20rys.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @mic_rys
Please kindly check the below.
The sample pbix file's link is down below.
Without Blue =
VAR bluetable =
SUMMARIZE (
FILTER (
SUMMARIZE ( 'Table', 'Table'[OrderID], 'Table'[Color] ),
'Table'[Color] = "Blue"
),
'Table'[OrderID]
)
VAR alltable =
VALUES ( 'Table'[OrderID] )
RETURN
COUNTROWS ( EXCEPT ( alltable, bluetable ) )
https://www.dropbox.com/s/jw8dfslfo4zte4j/mic%20rys.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
thank you a lot, works perfectly!
User | Count |
---|---|
57 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
116 | |
42 | |
40 | |
28 | |
22 |