Forum Discussion

Rodelaar's avatar
Rodelaar
Regular Visitor
3 years ago

Exclude data if description starts with Av

Hi,  I have this measure:    Rentals = CALCULATE(sum(GL_POSTINGS_MAIN[Bedragdc]),GL_POSTINGS_MAIN[ACCOUNT] = "4586")     But I need to exclude some of the results. The only way to do this at ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Rodelaar , Not very Clear, But you need measure like

 


Rentals = CALCULATE(sum(GL_POSTINGS_MAIN[Bedragdc]),filter(GL_POSTINGS_MAIN, GL_POSTINGS_MAIN[ACCOUNT] = "4586"))

 

or

 

 

Rentals = CALCULATE(sum(GL_POSTINGS_MAIN[Bedragdc]),filter(GL_POSTINGS_MAIN, GL_POSTINGS_MAIN[ACCOUNT] = "4586" && left(GL_POSTINGS_MAIN[ACCOUNT],2) <> "Av" ))