Forum Discussion

Puja's avatar
Puja
Helper III
3 years ago
Solved

Need Help please

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

 

 

 

 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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 )

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    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 )