topic Count Rows + greater than in DAX Commands and Tips

Count Rows + greater than

Anonymous — Tue, 12 Nov 2019 20:53:38 GMT

Hi!
Looking for some guidance with simple DAX Calculation.I created one Measure to count rows:

Measure = COUNTROWS(FullTable)

Then on a matrix table I add the following:

Lines:
Account Number
Transaction Number
Date of Transaction

Values:
Current Value
Measure

I want this table only to show "Account Numbers" that had more than 30 rows count. I just added a filter in the visual for measure field to show me "is greater than 30" but the table doesn't apply this filter.

Feel kind stupid since this sounds basic. But I fell this has something to do with those 2 extra lines I added (Transaction Number / Date of Transaction).

Can you guys help me?

Thanks,
Barbara

Re: Count Rows + greater than

VasTg — Tue, 12 Nov 2019 21:31:18 GMT

Anonymous

There must be a better way to achieve this, but here you go.

a. Create a new column in the table with value 1

New_Column = 1

b. Use the below measure to count the number of Accounts.

Accts Cnt = SUMX(SUMMARIZE('Blank Report','Blank Report'[Country],"ABC",CALCULATE(SUM('Blank Report'[Column]),ALLEXCEPT('Blank Report','Blank Report'[Country]))),[ABC])

Replace 'Blank Report' with you table name and Country with Accounts column.

If it helps, mark it as a solution.

Kudos are good too.

Re: Count Rows + greater than

Anonymous — Fri, 22 Nov 2019 15:18:06 GMT

Hi VasTg, How are you? Me again. I had worked perfected before but now I only need to show the distint count for "Transaction Numbers" and then filter it. In this formula you gave me, how do I changed it? Thanks, Barbara

Re: Count Rows + greater than

VasTg — Sat, 23 Nov 2019 23:48:09 GMT

Anonymous

I am doing good. Thanks for asking.

Do you mind share a sample input and output data?

Thanks,

Vas