Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am trying to count the total number of unique values from column number of which in column type have values a, c or f.
I think I should make a measure with a filter in it. I have the following:
measure =
VAR filter = Filter(table);
table[type] = "a"
|| table[type] = "c"
|| table[type] = "f"
VAR VAR2 = Filter(table; table[number])
RETURN
calculated( [measure =];
filter; VAR2
but I keep getting an error: Syntax error, at line 3, col 17
I don't understand what I'm doing wrong, hopefully someone can help me.
thank you
Solved! Go to Solution.
Hi @icturion ,
Would you please try to use the following measure?
Measure =
CALCULATE (
SUM ( 'Table '[number] ),
FILTER ( 'Table', 'Table'[type] IN { "a", "b", "f" } )
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @icturion ,
Would you please try to use the following measure?
Measure =
CALCULATE (
SUM ( 'Table '[number] ),
FILTER ( 'Table', 'Table'[type] IN { "a", "b", "f" } )
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |