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.
I am trying to write a DAX statement for NOT IN but i don't know the syntax for it. It's like:
Solved! Go to Solution.
Hi, @Anonymous ;
You could change to it.
q =
DIVIDE (
CALCULATE (
SUM ( C[T_S] ),
FILTER ( C, NOT ( C[S] ) IN { "C", "V", "D", "C" } )
),
SUM ( T_D[T_S] )
)
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous ;
You could change to it.
q =
DIVIDE (
CALCULATE (
SUM ( C[T_S] ),
FILTER ( C, NOT ( C[S] ) IN { "C", "V", "D", "C" } )
),
SUM ( T_D[T_S] )
)
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Replace || with &&. Remove the redundant condition - C[S]<>"C"
so, I wrote the denominator but the power bi is saying that "Operator or expression '( )' is not supported in this context."
The italic, underline part is showing error as: "Operator or expression '( )' is not supported in this context."
So, I wrote the denominator but the power bi is saying that "Operator or expression '( )' is not supported in this context."
The italic, underline part is showing error as: "Operator or expression '( )' is not supported in this context."
I tried to put the formula but it says "too few arguments were passed to the divide function. thhe minimum argument count for the functions is 2".
Hi @Anonymous,
You have missed out argument 2 in the DIVIDE function. You have only specified the numerator in the function.
DIVIDE(CALCULATE(sum(C[T_S]), Filter(C, not( C[S] in {"C" ,"V","D","C"}))) , ____ )
If this solves your issue, please mark @amitchandak 's answer as the solution to help others too.
Kind regards,
Rohit
Appreciate your kudos! 😊
@Anonymous , Try like
CALCULATE(sum(C[T_S]), Filter(C, not( C[S] in {"C" ,V","D","C"} ) ) )
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 |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |