Forum Discussion
Count Rows + greater than
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 ...
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.
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.
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
Anonymous
I am doing good. Thanks for asking.
Do you mind share a sample input and output data?
Thanks,
Vas