Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
having this table :
Code Group Processing Status
101 | Jeans | 1 | Ordered |
101 | Jeans | 1 | Ordered |
102 | Jeans | 1 | In Delivery |
103 | Shirt | 3 | In Delivery |
104 | Shirt | 3 | In Delivery |
105 | Shirt | 3 | In Delivery |
106 | Shirt | 3 | Sold |
107 | Shoe | 66 | Sold |
I have this measurment :
Status count per Code = var _status = SELECTEDVALUE('Table'[Status])
var _processing =SUMX(SUMMARIZE('Table','Table'[Group],'Table'[Processing]),'Table'[Processing])
var _t=DISTINCT(SELECTCOLUMNS( FILTER( ALLSELECTED('Table') ,'Table'[Status]=_status) , "Code" , [Code]))
return
IF(_status ="Sold" , _processing , COUNTROWS(_t))
Solved! Go to Solution.
Hi @MasterSonic
please try
Status count per Code =
VAR _status =
SELECTEDVALUE ( 'Table'[Status] )
VAR _processing =
SUMX (
SUMMARIZE ( ALLSELECTED ( 'Table' ), 'Table'[Group], 'Table'[Processing] ),
'Table'[Processing]
)
VAR _t =
DISTINCT (
SELECTCOLUMNS (
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Status] = _status ),
"Code", [Code]
)
)
RETURN
IF ( _status = "Sold", _processing, COUNTROWS ( _t ) )
Hi @MasterSonic
please try
Status count per Code =
VAR _status =
SELECTEDVALUE ( 'Table'[Status] )
VAR _processing =
SUMX (
SUMMARIZE ( ALLSELECTED ( 'Table' ), 'Table'[Group], 'Table'[Processing] ),
'Table'[Processing]
)
VAR _t =
DISTINCT (
SELECTCOLUMNS (
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Status] = _status ),
"Code", [Code]
)
)
RETURN
IF ( _status = "Sold", _processing, COUNTROWS ( _t ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
77 | |
61 | |
47 | |
17 | |
12 |