Forum Discussion

MarcDT21's avatar
MarcDT21
Frequent Visitor
5 years ago
Solved

Calculated measure with filter

Hi there!  I would like to answear the qestion, "how many kilometers have been driven since the last inspection?" Was the inspection (KontrOelAdblueetc) made then it's TRUE. So I somehow need to get...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi MarcDT21 

     

    I didn't know what FZ column represents for so I ignored that in previous reply. Anyway, try this new measure 2:

    Measure 2 = 
VAR current_FZ_table = FILTER(ALL('Table'),'Table'[FZ]=SELECTEDVALUE('Table'[FZ]))
VAR last_true_date = MAXX(FILTER(current_FZ_table,'Table'[KontrOelAdblueect]=TRUE()),'Table'[Datum])
VAR last_true_date_KM = MAXX(FILTER(current_FZ_table,'Table'[Datum]=last_true_date),'Table'[KMEnde])
VAR last_date = MAXX(current_FZ_table,'Table'[Datum])
VAR last_date_KM = MAXX(FILTER(current_FZ_table,'Table'[Datum]=last_date),[KMEnde])
RETURN
last_date_KM - last_true_date_KM

     

    Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Hi @MarcDT21 

 

You can try these measures

Measure = 
VAR last_true_date = MAXX(FILTER(ALL('Table'),'Table'[KontrOelAdblueect]=TRUE()),'Table'[Datum])
RETURN
SUMX(FILTER(ALL('Table'),'Table'[Datum]>last_true_date),'Table'[GefahreneDistanz])

or

Measure 2 = 
VAR last_true_date = MAXX(FILTER(ALL('Table'),'Table'[KontrOelAdblueect]=TRUE()),'Table'[Datum])
VAR last_true_date_KM = MAXX(FILTER(ALL('Table'),'Table'[Datum]=last_true_date),'Table'[KMEnde])
VAR last_date_KM = MAXX(FILTER(ALL('Table'),'Table'[Datum]=MAX('Table'[Datum])),[KMEnde])
RETURN
last_date_KM - last_true_date_KM

083002.jpg

 

Let me know if you have any questions. 

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.