Forum Discussion

smoothbrain's avatar
smoothbrain
New Member
2 years ago
Solved

Multiple COUNTROWS?

Hey team,  I'm a chimp at a typewriter trying to lean into PowerBI. Not terrifically experience with DAX, but am the desinated 'data' person.  Is it possible to sum multiple Countrows? An activ...
COUNTROWS
DAX
powerbi
sum
  • aduguid's avatar
    aduguid
    2 years ago

    I would create a calculated column in your table. Then all you need to do is SUM the calculated column.

     

    NewStatusColumn = 
SWITCH(
    TRUE(),
    'DataTable'[Program] = "Program1" && 'DataTable'[Status] = "Active", 5,
    'DataTable'[Program] = "Program1" && 'DataTable'[Status] = "Passive", 2,
    BLANK()  // Default value if none of the conditions are met
)

     

     

  • tharunkumarRTK's avatar
    tharunkumarRTK
    2 years ago

    smoothbrain 

    You can do it in this way.

     

    SUMX(DataTable, if( 'DataTable'[Status] = "Passive" && 'DataTable'[Program] = "Program1", 2,  if( 'DataTable'[Status] = "Active" && 'DataTable'[Program] = "Program1", 5)))

     



    Need Power BI consultation, hire me on UpWork .


    If the post helps please give a thumbs up



    If it solves your issue, please accept it as the solution to help the other members find it more quickly.




    Tharun



     

aduguid's avatar
aduguid
Memorable Member
2 years ago

I would create a calculated column in your table. Then all you need to do is SUM the calculated column.

 

NewStatusColumn = 
SWITCH(
    TRUE(),
    'DataTable'[Program] = "Program1" && 'DataTable'[Status] = "Active", 5,
    'DataTable'[Program] = "Program1" && 'DataTable'[Status] = "Passive", 2,
    BLANK()  // Default value if none of the conditions are met
)