topic Re: if else in Power Bi calculated column in DAX Commands and Tips

if else in Power Bi calculated column

Anonymous — Mon, 29 Aug 2022 08:28:36 GMT

Hi everyone,

Im trying to create a range where value is "Less than 50", "More than 50" and "More than 150". I was able to achieve this but I want values that are more than 50 to display inclusive of values more than 150 as well. User should have an option to only to view all data that are more than 50 and if they want to view values more than 150 they should be able to select that.

Range = SWITCH(
TRUE(), 
'All'[Value (USD)] < 50, "Less than 50",
'All'[Value (USD)] > 50 && 'All'[Value (USD)] < 150 , "More than 50",
'All'[Value (USD)] > 150, "More than 150")

This code will segregate data with value 50 and 150. I would like to know if its possible to display data that are more than 50 & 150 when user select "More than 50". If user selects more than 150 then it will only display data with value more than 150.
I hope someone could give a suggestion for this 🙂

Re: if else in Power Bi calculated column

tamerj1 — Mon, 29 Aug 2022 08:51:25 GMT

Hi Anonymous

you can create or import a separate disconnected table that contains the three text descriptions of the three rangges let's call it 'Ranges' that contains one column [Range]. Inserr a sclicer based on 'Ranges[Range]. Place the following measure in the filter pane of the visual, select "is not blank" and apply the filter

Range = SWITCH ( SELECTEDVALUE ( Ranges[Range] ), "Less than 50", COUNTROWS ( FILTER ( 'All', 'All'[Value (USD)] < 50 ) ), "More than 50", COUNTROWS ( FILTER ( 'All', 'All'[Value (USD)] > 50 ) ), "More than 150", COUNTROWS ( FILTER ( 'All', 'All'[Value (USD)] > 150 ) ) )

Re: if else in Power Bi calculated column

Anonymous — Mon, 29 Aug 2022 09:45:15 GMT

Hi tamerj1 ,
Ive tried the suggested method but it only displays "More than 150" even when all 3 ranges are in table.

Re: if else in Power Bi calculated column

tamerj1 — Mon, 29 Aug 2022 10:09:20 GMT

Anonymous
Would you please share a screenshot of what you've achieved so far?

Re: if else in Power Bi calculated column

Anonymous — Tue, 30 Aug 2022 00:16:16 GMT

Its an empty table when i create a table using this measure. When I use it as a slicer for my existing dashboard it only shows More than 150.

Re: if else in Power Bi calculated column

Anonymous — Tue, 30 Aug 2022 01:17:46 GMT

Hi its alright I made it work, thank you for your input 🙂