'Power BI Measure with filter based on other measure
I made a measure to find Top Defect as text for last week.
Def 1 = CALCULATE(max('sum'[ScrapCode]), FILTER('sum', 'sum'[KW]=[Nr Last KW])
[Nr Last KW]) is the last KW
Than I want to use this Defect to filter the table. But there ist only last week in new table. How can I remove filter for last week, but only in calculated table?
Table = CALCULATETABLE('sum', FILTER('sum', 'sum'[ScrapCode]=[Def 1]))
Table = CALCULATETABLE('sum', FILTER(ALL('sum'), 'sum'[ScrapCode]=[Def 1])) doesn't work. There is only last week too.
Thanks
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
