topic Calculated column DAX in DAX Commands and Tips

Calculated column DAX

Anonymous — Thu, 22 Aug 2024 19:52:04 GMT

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

Re: Calculated column DAX

gmsamborn — Thu, 22 Aug 2024 20:26:31 GMT

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 _Result

Let me know if you have any questions.

Thimma_pbi.pbix

Re: Calculated column DAX

jgeddes — Thu, 22 Aug 2024 20:27:38 GMT

Maybe this?

Column = CALCULATE( COUNT('Table'[Sr No]), ALLEXCEPT('Table', 'Table'[Order Date]) )

Re: Calculated column DAX

Greg_Deckler — Thu, 22 Aug 2024 20:35:57 GMT

Anonymous Here's one more solution, PBIX is attached.

Column = VAR __Date = [Order Date] VAR __Result = COUNTROWS( FILTER( 'Table', [Order Date] = __Date ) ) RETURN __Result

Re: Calculated column DAX

Anonymous — Thu, 22 Aug 2024 20:47:40 GMT

actually, calculated column should count on number of products and based on the corresponding date. if apple and samsung present data in some other day that should give value on that day only.

Re: Calculated column DAX

Greg_Deckler — Thu, 22 Aug 2024 20:51:10 GMT

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