Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX 'EXCEPT' FUNCTION NOT WORKINT

Hi there,   I have  table A  called 'CIA_List_Impacted Team'. It has only one column called 'Impacted Team'.   When a slicer is applied to the column 'Impacted Team' in Table A, I want to create ...
Need Help
  • OwenAuger's avatar
    OwenAuger
    7 years ago

    Hi Anonymous 

    Calculated tables (and calculated columns) are computed during report refresh, and are then static, i.e. don't change based on interaction with the report.

    (See this article for discussion of creating "table functions" using DETAILROWS in Analysis Services but not Power BI)

     

    You could use the EXCEPT(...) expression within a measure however, to act as a filter for some calculation for example. But you would have to repeat the expression within every measure that depended on it.

     

    Regards,

    Owen

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
7 years ago

Hi Anonymous 

Calculated tables (and calculated columns) are computed during report refresh, and are then static, i.e. don't change based on interaction with the report.

(See this article for discussion of creating "table functions" using DETAILROWS in Analysis Services but not Power BI)

 

You could use the EXCEPT(...) expression within a measure however, to act as a filter for some calculation for example. But you would have to repeat the expression within every measure that depended on it.

 

Regards,

Owen

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Owen.