Dax Script

[Anonymous]

hello all, 

i'm wondering if someone can help m, being trying to make this measure since the last 1 week now 

my client asked me to produce a dashboard displaying only the last message received

here is the scenario.

its a reservation system, users have id call PDL and eache PDL can have one or multiple message when booking an appointement.

types of message:

- Prise de rdv en succès

-proposition possible

pas de possibilité de rdv 

etc..

now the mesure that i need to create is the count of all last message per max(hour).

i made the following script 

test_mesure:=CALCULATE( DISTINCTCOUNT('ANALYSE PRV MESURES'[PDL]); LASTNONBLANK('ANALYSE PRV MESURES'[DATETIME];'ANALYSE PRV MESURES'[DATETIME])

)

and this is not working. 

someone has an idea on how to make it ?

[Anonymous]

Hi @Anonymous 

Could you please share sample dataset and expected output.

Thanks,

pravin