topic Re: Need Help please in DAX Commands and Tips

Need Help please

Puja — Sat, 15 Apr 2023 00:28:01 GMT

I have a measure working as expected(below).

SalesCount = IF(
[QTY] <= 0,
"A",
IF(
ABS(1 - DIVIDE([Sales1], [Sales2])) < 10,
"B",
"A"
)
)

I need to count number of rows equal to "A" and

number of rows equal to "B" . For this calculations, I need to use measure.

Please help.

Thanks

Re: Need Help please

Jihwan_Kim — Sat, 15 Apr 2023 03:17:17 GMT

Hi,

I am not sure how your datamodel, and how your expected visualization looks like, but please try the below.

Count A: = VAR _tableA = FILTER ( ADDCOLUMNS ( VALUES ( TableName[ColumnInTheVisualization] ), "@salescount", [SalesCountMeasure] ), [@salescount] = "A" ) RETURN COUNTROWS ( _tableA )

Count B: = VAR _tableB = FILTER ( ADDCOLUMNS ( VALUES ( TableName[ColumnInTheVisualization] ), "@salescount", [SalesCountMeasure] ), [@salescount] = "B" ) RETURN COUNTROWS ( _tableB )

Re: Need Help please

Puja — Sun, 16 Apr 2023 16:54:51 GMT

Hi Jihwan_Kim ,

Thank you somuch for the perfect solution 🙂