Distinct Count in new Column show blank result in table

[Anonymous]

Hi All, I have a distinct count "New column"

distinctcount__ = CALCULATE(DISTINCTCOUNT(HistoricalBO[Index])). It should count all index rows that in 2020, but it shows blanks(see the picture below)

I tried to use new measure. it worked. But I need to be new column for further calculation.

Thank you all.

[camargos88]

@Anonymous ,

Can you provide more examples of your dataset ?

[Anonymous]

@camargos88 
Three columns. year, item , index( as a unique row reference)

I want to get how many items in a year. so I counted the index in a new column.

distinctcount__ = CALCULATE(DISTINCTCOUNT(HistoricalBO[Index]))

Year     Distinctcount

2020  _nothing show_

[camargos88]

@Anonymous ,

It maybe be necessary take a look at your pbix file to check the modeling, your measure should work.

[Anonymous]

@camargos88  only one table , 3 columns, no data model applied.  no filter applied in the page. 

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

Please delete that calculated column and try to recreate a new calculated column with below formula:

distinctcount__ =
CALCULATE (
    DISTINCTCOUNT ( HistoricalBO[Index] ),
    FILTER (
        'HistoricalBO',
        'HistoricalBO'[Year] = EARLIER ( 'HistoricalBO'[Year] )
    )
)

If the above one still get blank values, please provide some sample data in your model(exclude sensitive data). Thank you.

Best Regards

Rena

[camargos88]

@Anonymous ,

Can you share this pbix ?