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.
Good day,
Hope someone can help me with the following.
I am looking for a measure (not a calculated column) to exclude the CONTAINER_NR, which is in the list more than once (yellow marked in the example below).
So, if the HASH is the same, as well as the CONTAINER NR, it should be exluded.
Thanks upfront for you help,
John
Solved! Go to Solution.
Well, it depends what you want to do, and what your table structure is, but if I assume you just have one table.
=countrows(filter(all(table[container_nr],table[hash]),calculate(countrows(table))=1))
put container_nr on rows in a matrix, and the above measure in the values section.
Well, it depends what you want to do, and what your table structure is, but if I assume you just have one table.
=countrows(filter(all(table[container_nr],table[hash]),calculate(countrows(table))=1))
put container_nr on rows in a matrix, and the above measure in the values section.
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 |
---|---|
89 | |
81 | |
65 | |
65 | |
61 |
User | Count |
---|---|
170 | |
115 | |
100 | |
73 | |
67 |