DAX: Need to create a another column for Percentage Slicers

[harirao]

Hi All,

Required assistance, I have created a column by using Divide function, result is showing in percentage.
Now i want to create another column/measure by using this, where i have segregate 0 to 20%, 21% to 50% &  >51%, so that i can use this as slicer.

Regards,

[amitchandak]

@harirao 

Refer: Binning and grouping

https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

[Pragati11 · Accepted solution]

Hi @harirao ,

You can create a column using the following DAX expression:

Percentage Grouping = IF((Percentage[Percentage]*100) >= 0 && (Percentage[Percentage]*100) < 21, "0 to 20%",    IF((Percentage[Percentage]*100) >= 21 && (Percentage[Percentage]*100) < 51, "21% to 50%"), "> 51%"))

NOTE: Replcae Percentage[Percentage] column in above DAX with your percentage column.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[harirao]

Thanks, this solution worked.

Regards,

Hari

[Pragati11]

Hi @harirao ,

Can you please accept the solution which worked for you?

Thanks,

Pragati

[Stachu]

Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).

Column1	Column2
A	1
B	2.5