Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.
User | Count |
---|---|
106 | |
89 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |