Forum Discussion

EricKautz's avatar
EricKautz
Helper 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

muhammad_786_1's avatar
muhammad_786_1
Solution 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
Helper I
2 years ago

This worked for me, thank you.