Forum Discussion

Shota_Xuc's avatar
Shota_Xuc
Helper I
2 years ago

Count rows with same value in one column

Hello,   I have a column "Valuation date" with dates like: 2024-02-06 2024-02-06 2024-02-06 2024-02-07 2024-02-07 2024-02-07 2024-02-09 2024-02-10 2024-02-10 2024-02-12 2024-02-12 2024-...
"Need Help"
Shota_Xuc's avatar
Shota_Xuc
Helper I
2 years ago

NickDanger 

it does not work, I have adjusted your code to my visual, here is my code:

Test Measure =
var _SelectedValueDate = SELECTEDVALUE('SFX_TRS_RESET_MATURITY_DATES'[Valuation date])
RETURN
CALCULATE(
    COUNTROWS('SFX_TRS_RESET_MATURITY_DATES'),
    ALL('SFX_TRS_RESET_MATURITY_DATES'), //Add any columns here that you're filtering on
    'SFX_TRS_RESET_MATURITY_DATES'[Valuation date] = _SelectedValueDate)
and I get wrong numbers:

 

 
NickDanger's avatar
NickDanger
Regular Visitor
2 years ago

Sorry if there was confusion, but your code does not match mine. You need to use 

ALLEXCEPT('SFX_TRS_RESET_MATURITY_DATES', 'SFX_TRS_RESET_MATURITY_DATES'[FILTERED COLUMN HERE]])


Not ALL('SFX_TRS_RESET_MATURITY_DATES')

If you're filtering on more than one column, separate them with a comma after each column listed. 

  • Shota_Xuc's avatar
    Shota_Xuc
    Helper I
    2 years ago

    NickDanger 

    I am not filtering on more than one column, 

    I tried the below code, but I get wrong numbers:

     

    Test Measure =
    var _SelectedValueDate = SELECTEDVALUE('SFX_TRS_RESET_MATURITY_DATES'[Valuation date])
    RETURN
    CALCULATE(
        COUNTROWS('SFX_TRS_RESET_MATURITY_DATES'),
        ALLEXCEPT('SFX_TRS_RESET_MATURITY_DATES', SFX_TRS_RESET_MATURITY_DATES[Valuation date]), //Add any columns here that you're filtering on
        'SFX_TRS_RESET_MATURITY_DATES'[Valuation date] = _SelectedValueDate)