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.
Hey Everyone,
I am having some issue with ISINSCOPE Function.
i have this simple table:
I am getting this as result:
I am using this measure:
Solved! Go to Solution.
Hi @TaroGulati
You could try this measure
NewMeasure =
SWITCH (
TRUE (),
ISINSCOPE ( 'Table'[Third level] ),
SWITCH (
SELECTEDVALUE ( 'Table'[Third level] ),
BLANK (), BLANK (),
"", BLANK (),
30
),
ISINSCOPE ( 'Table'[Second level] ),
SWITCH (
SELECTEDVALUE ( 'Table'[Second level] ),
BLANK (), BLANK (),
"", BLANK (),
20
),
ISINSCOPE ( 'Table'[First level] ), 10,
BLANK ()
)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @TaroGulati
You could try this measure
NewMeasure =
SWITCH (
TRUE (),
ISINSCOPE ( 'Table'[Third level] ),
SWITCH (
SELECTEDVALUE ( 'Table'[Third level] ),
BLANK (), BLANK (),
"", BLANK (),
30
),
ISINSCOPE ( 'Table'[Second level] ),
SWITCH (
SELECTEDVALUE ( 'Table'[Second level] ),
BLANK (), BLANK (),
"", BLANK (),
20
),
ISINSCOPE ( 'Table'[First level] ), 10,
BLANK ()
)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
@TaroGulati , for that you have check blank too
SWITCH(TRUE(), ISINSCOPE('Table'[Third level]) && not(isblank('Table'[Third level])) ,30,
ISINSCOPE('Table'[Second level]) && not(isblank('Table'[Second level])) ,20
,ISINSCOPE('Table'[First level]),10, blank() )
@amitchandak thanks for your kind reply.
i am having one issue to validate this measure. ISBLANK function is not accepting the column of table.
Should i use it in some different way?
thanks
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |