Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi experts,
I have a complex table, but I have summarized it as the following:
SUMMARIZE(Table,Table[Period],"Sales",SUM(Table[Sales_unit]))
So now I have:
Period | Sales |
2023 | 100 |
2022 | 100 |
2021 | 0 |
I want a measure, that shows me the [Period] when [Sales] = 0 (in the example, the answer is 2021). I was trying with minx
MINX(FILTER(SUMMARIZE(Table,Table[Period],"Sales_unit",SUM(Table[Sales_unit])),[Sales] = 0),[Period])
But this measure shows me a dynamic range that is not the wanted result 😞
Any help is appreciated. Thanks
@Smackcat , You should use sales in the sum,
MINX(FILTER(SUMMARIZE(Table,Table[Period],"Sales_unit",SUM(Table[sales])),[Sales_unit] = 0),[Period])
of you can use all or allselected
MINX(FILTER(SUMMARIZE(all(Table) ,Table[Period],"Sales_unit",SUM(Table[sales])),[Sales_unit] = 0),[Period])
or
MINX(FILTER(SUMMARIZE(allselected(Table) ,Table[Period],"Sales_unit",SUM(Table[sales])),[Sales_unit] = 0),[Period])
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |