Forum Discussion

EricKautz's avatar
EricKautz
Icon for Helper I rankHelper I
2 years ago
Solved

Countrows function for 2 colums

Good afternoon,   I am trying to create a measure to count the number of rows that meet 2 different column criteria and the dax equation I'm using is not pulling in the correct total. The count is ...
Need Help
  • muhammad_786_1's avatar
    muhammad_786_1
    2 years ago

    I hope it'll work for you.

     

    MTM Greater than 10,000 and 1 =
    CALCULATE(
    COUNTROWS('cftc 10 %'),
    'cftc 10 %'[ABSMTMDifferenceValue] > 10000,
    'cftc 10 %'[age] = "1"
    )

    This approach correctly counts the rows per AssetClass that meet your both criteria.

     

     

    My suggestion: It's better to avoid spaces in table and column names to keep your DAX formulas cleaner and more readable.

     

    Best Regards,
    Muhammad Yousaf

     

    If this post helps, then please consider "Accept it as the solution" to help the other members find it more quickly.

     

    Follow on LinkedIn

sevenhills's avatar
sevenhills
Icon for Super User rankSuper User
2 years ago

Try with ALLSELECTED in place of ALL and see if it works!

  • EricKautz's avatar
    EricKautz
    Icon for Helper I rankHelper I
    2 years ago

    No, it did not work.

    • muhammad_786_1's avatar
      muhammad_786_1
      Icon for Solution Supplier rankSolution Supplier
      2 years ago

      I hope it'll work for you.

       

      MTM Greater than 10,000 and 1 =
      CALCULATE(
      COUNTROWS('cftc 10 %'),
      'cftc 10 %'[ABSMTMDifferenceValue] > 10000,
      'cftc 10 %'[age] = "1"
      )

      This approach correctly counts the rows per AssetClass that meet your both criteria.

       

       

      My suggestion: It's better to avoid spaces in table and column names to keep your DAX formulas cleaner and more readable.

       

      Best Regards,
      Muhammad Yousaf

       

      If this post helps, then please consider "Accept it as the solution" to help the other members find it more quickly.

       

      Follow on LinkedIn

      • EricKautz's avatar
        EricKautz
        Icon for Helper I rankHelper I
        2 years ago

        This worked for me, thank you.