Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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.
@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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |