dreid1011
Well-known Member
- Joined
- Jun 4, 2015
- Messages
- 3,442
- Office Version
- 365
- Platform
- Windows
I have a measure to count the number of rows for each unique account id, but now I would like to only count the number of rows for each account id where the value in another column is greater than 0.
Current measure counting number of rows for each unique account id:
YEARS OWING = CALCULATE(COUNT('ASSESS V_TAX_TOTALS'[TA_ID]),ALL('ASSESS V_TAX_TOTALS'),VALUES('ASSESS V_TAX_TOTALS'[TA_ID]))
On my visualization, I have filtered out the 0 amounts in the other column, but the measure is still counting those rows.
Current measure counting number of rows for each unique account id:
YEARS OWING = CALCULATE(COUNT('ASSESS V_TAX_TOTALS'[TA_ID]),ALL('ASSESS V_TAX_TOTALS'),VALUES('ASSESS V_TAX_TOTALS'[TA_ID]))
On my visualization, I have filtered out the 0 amounts in the other column, but the measure is still counting those rows.