Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm wondering, is power bi capable to store IF conditions in a variable?
example
var kondisi = 1 //using a dropdown, it will change value either 1 or 2
VAR param_kondisi =
IF(kondisi = 1,
'Table'[Population 1] <> BLANK(),
'Table'[Population 2] <> BLANK()
)
Var Calculate_Result =
CALCULATE(
COUNT('Table'[primkey]),
KEEPFILTERS(
'Table'[client_name] = "Superman"
&& param_kondisi
)
)
any suggestion would be very appreciated,
thank you
@the001 , it should return true or false
try like
Calculate_Result =
CALCULATE(
COUNT('00. SPK'[primkey]),
KEEPFILTERS(
'Table'[client_name] = "Superman"
&& ((kondisi = 1 && 'Table'[Population 1] <> BLANK()) || (kondisi <> 1 && 'Table'[Population 2] <> BLANK()))
)
)
thanks! it returns correctly
but is there any chance that pattern as I mentioned earlier, is possible in power bi?
@the001 , Just make sure it returns true or false
like
IF(kondisi = 1,
if('Table'[Population 1] <> BLANK(),true(), false())
if('Table'[Population 2] <> BLANK(),true(), false())
)
it does not return true or false, but it is returned as a condition inside the variable calculate_result
it is returned as it was like below :
Var Calculate_Result =
CALCULATE(
COUNT('Table'[primkey]),
KEEPFILTERS(
'Table'[client_name] = "Superman"
&& IF(kondisi = 1,
'Table'[Population 1] <> BLANK(),
'Table'[Population 2] <> BLANK()
)
)
)
Hi @the001 ,
I'm not quite sure what you want... According to the formula you provided, the result returned by the variable Calculate_Result should be a numeric value: the number of primkeys. And the formula syntax of the variable Calculate_Result is also correct. Could you please provide a simple sample data and the final result you want? Maybe we can implement your requirement in some other way later. Thank you.
Best Regards
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |