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,
I am having troubles with filtering out a few rows from my data set. I have created a small example below. I want to exclude the rows where [ContractNO] = MM005 and where [Number] = 100, 101, 102, 103 and 104. The expected result are seen in picture 2.
And the expected outcome to:
Hope someone can help me.
Best regards
Line
Solved! Go to Solution.
@Anonymous , Create a measure like this one and use it with other non summarized columns
countrows(filter(Table, not([ContractNO] = "MM005" && [Number] in{ 100, 101, 102, 103 , 104})))
Hi @Anonymous ,
This might be because the Number Column might be an integer. Try changing it to Text Datatype.
Hi @Anonymous ,
This might be because the Number Column might be an integer. Try changing it to Text Datatype.
@Anonymous , Create a measure like this one and use it with other non summarized columns
countrows(filter(Table, not([ContractNO] = "MM005" && [Number] in{ 100, 101, 102, 103 , 104})))
I have tried to create the measure in my dataset, but get an error saying that the function does not support comparing values of type integer with values of type text.
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 |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |