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.
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
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |