Dax measure to show count of today's date data

[jibran]

Hi,

I am working on to create a sales dashboard for our team and stuck on one of the formula in which I want to show total amount of customers join us on today's date. When customer join our portal we store the date as of Create date on our database. I tried this formula 

TodayDate = FILTER(aspnet_membership,aspnet_membership[CreateDate] = TODAY())

 But it cameup with an error that Multiple columns cannot be converted to a scalar value.

Can you please assist me on this?

I can provide more information with screen shot if needed.

Many Thanks

[v-haibl-msft · Accepted solution]

@jibran

Not sure what is aspnet_membership table like. I assuming we have a table like below.

We can create a measure with following DAX formula.

Measure = 
CALCULATE (
    DISTINCTCOUNT ( aspnet_membership[Customer Join] ),
    aspnet_membership[CreateDate] = TODAY ()
)

Best Regards,

Herbert

[jibran]

Hi,

I tried to add below formula but still is not displaying today's date data.

Formula that I use is 

Vehicle Addition Counter1 = CALCULATE ( DISTINCTCOUNT( vehicles[ID] ), Vehicles[DateAdded] = TODAY())

 

[v-haibl-msft]

@jibran

Which visual did you use for this measure “Vehicle Addition Counter1”?

If possible, could you please provide your PBIX file to me?

Best Regards,

Herbert

[jibran]

Hi Herbert,

Thanks for your help actually your formula was right I just had to change the date transformation to make it worked

Thanka a lot for your help

Many Thanks

Jibran Ishtiaq

[Anonymous]

Hi @jibran,

I'm not getting anything using this formula. Could you please explain how you transformed the date.

Thank you

Regards

Sunil