Forum Discussion

Mamoun_issa's avatar
Mamoun_issa
Frequent Visitor
6 years ago

Latest Invoice Amount - Iternation

Hello,   I Have a table of invoices to that was submitted to the health insurance company that looks similar to this:   Invoice No. Mode (1- submission, 2- Resubmissition, 3- Correction) Amo...
DAX
Iterator
power bi
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Mamoun_issa - You could do that as a measure in a table visualization with Invoice No. I mocked it up and provided a sample PBIX for you. It is Table (10), Measure (10) on Page 10.

Measure 10 = 
    VAR __ModeMax = MAX([Mode])
RETURN
    MAXX(FILTER('Table (10)',[Mode] = __ModeMax),[Amount])

See attached PBIX below sig.