Forum Discussion
Calculated column DAX
Hi,
I have below table and wanted to create calculated column as expected results in the box.
Any help.
| Sr No | Product | Order Date | Apple qty | Samsung Qty | Nokia qty | Calculated Column |
| 1 | Apple | 01-Jan-24 | 10 | 2 | ||
| 2 | Samsung | 01-Jan-24 | 20 | 2 | ||
| 3 | Apple | 02-Jan-24 | 50 | 3 | ||
| 4 | Samsung | 02-Jan-24 | 30 | 3 | ||
| 5 | Nokia | 02-Jan-24 | 25 | 3 | ||
| 6 | Apple | 03-Jan-24 | 20 | 3 | ||
| 7 | Samsung | 03-Jan-24 | 100 | 3 | ||
| 8 | Nokia | 03-Jan-24 | 50 | 3 |
Anonymous So like this?
Column = VAR __Date = [Order Date] VAR __Table = FILTER( 'Table', [Order Date] = __Date ) ) VAR __Result = COUNTROWS( DISTINCT( SELECTCOLUMNS( __Table, "Product", [Product] ) ) ) RETURN __Result
5 Replies
Hi Anonymous
I'm assuming you want to find the number of order lines per date.
MyColumn = VAR _Curr = [Order Date] VAR _Result = CALCULATE( COUNTROWS( ALLSELECTED( 'Table' ) ), 'Table'[Order Date] = _Curr ) RETURN _ResultLet me know if you have any questions.
Maybe this?
Column = CALCULATE( COUNT('Table'[Sr No]), ALLEXCEPT('Table', 'Table'[Order Date]) )Anonymous Here's one more solution, PBIX is attached.
Column = VAR __Date = [Order Date] VAR __Result = COUNTROWS( FILTER( 'Table', [Order Date] = __Date ) ) RETURN __ResultAnonymous So like this?
Column = VAR __Date = [Order Date] VAR __Table = FILTER( 'Table', [Order Date] = __Date ) ) VAR __Result = COUNTROWS( DISTINCT( SELECTCOLUMNS( __Table, "Product", [Product] ) ) ) RETURN __Result
