Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
50 | |
24 | |
18 | |
17 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
25 | |
21 |