Forum Discussion
DAX 'EXCEPT' FUNCTION NOT WORKINT
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
Super UserHi 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 Owen,
Is there any way I can have Table B, using the current functionality in Power BI? Thanks.
- OwenAuger
Hi Iris,
What behaviour are you trying to produce exactly?
There is no way to have Table B as a physical table update based on a slicer selection or other filter in the report.
However you can have a table created using DAX code within a measure update based on slicers.
Hi Owen,
It's ok - I've decided not to pursue down this path. Thanks heaps for your help.
Iris