Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Exclude values using DAX

Can you please advise how to solve the following issue: We have several Research activities that are part of the same 'Opdracht', so they have the same OPDRACHTID. Some activities are already invoice...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    Try this calculated table

    From Modelling tab>>>NEw Table

     

    Calculated Table =
VAR IDs_with_factur =
    CALCULATETABLE (
        VALUES ( Table1[OPDRACHTID] ),
        FILTER ( Table1, Table1[factuurID] <> BLANK () )
    )
VAR IDs_without_factur =
    EXCEPT ( VALUES ( Table1[OPDRACHTID] ), IDs_with_factur )
RETURN
    FILTER ( Table1, Table1[OPDRACHTID] IN IDs_without_factur )
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Anonymous

 

Try this calculated table

From Modelling tab>>>NEw Table

 

Calculated Table =
VAR IDs_with_factur =
    CALCULATETABLE (
        VALUES ( Table1[OPDRACHTID] ),
        FILTER ( Table1, Table1[factuurID] <> BLANK () )
    )
VAR IDs_without_factur =
    EXCEPT ( VALUES ( Table1[OPDRACHTID] ), IDs_with_factur )
RETURN
    FILTER ( Table1, Table1[OPDRACHTID] IN IDs_without_factur )
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks very much Zubair_Muhammad!! This solved my problem.