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"  an...
  • 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 )
  • Puja's avatar
    Puja
    3 years ago

    Hi Jihwan_Kim ,

    Thank you somuch for the perfect solution 🙂

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 )