Forum Discussion
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 ...
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
Hi,
Can you provide us some sample data.
And what does your slicer has ?
Thanks,
Tejaswi