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 all,
I am working on a report for new product development.
There are some KPI's (numbers) I want to show.
For example:
Count of products that reach >= 20000kg's or >=7500 margin.
So 2 filters from different value sources (weight and margin)
The idea is very simple, but I can't figure out a solution to count the products....
Thanks in advance
Camiel
Solved! Go to Solution.
@ckleppe ,
Try like
countx(filter(summarize(Table,Table[product],"_r",sum(Table[reach]),"_m" ,sum(table[margin])),[_r]>=20000 || _m >=7500 ),[product])
@ckleppe ,
Try like
countx(filter(summarize(Table,Table[product],"_r",sum(Table[reach]),"_m" ,sum(table[margin])),[_r]>=20000 || _m >=7500 ),[product])
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
99 | |
73 | |
65 |