Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Display all values when values are blank or missing

I need to use DAX (not power query) to only display the whole record where there is a gap in revenue or the future revenues are blank. I've calculated the revenue and the revenue MoM but am strugglin...
DAX
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 

please try

Revenue New =
IF (
    [Project Revenue MoM Flag] = 1,
    CALCULATE ( [Project Revenue], ALLSELECTED ( 'Date' ) ),
    [Revenue]
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for your reply. I don't understand how this will help me filter the visual to only include codes with a gap in revenue or missing revenue. Would you please explain further?