Does Power BI have an alternative for Calculated Dimension

[Anonymous]

Dear All

I am trying to create a calculated dimension like below calcualted measure, I would like to put this under the Rows or Columns tab under the Visualizations pane. But Power Bi is not allowing me to do the same. Basically this is a text field which gets populated based on a measure value. How can i do this with Power BI? 

I would like to see a result like below, when i try to keep the  measure <Caclulated Dimension 1> under the values pane then it shows only 1 row and not all of possible values of the calcualted Dimension ( measure )

<Caclulated Dimension 1> <Caclulated Measure 1> <Caclulated Measure 2><Caclulated Measure 3>

<Caclulated Dimension 2> <Caclulated Measure 1> <Caclulated Measure 2><Caclulated Measure 3>

<Caclulated Dimension 3> <Caclulated Measure 1> <Caclulated Measure 2><Caclulated Measure 3>

<Caclulated Dimension 4><Caclulated Measure 1> <Caclulated Measure 2><Caclulated Measure 3>

User Tier 1 =

    var v_Sum_Curr_Prd_Diff_Mg_Seats=  [Current Period Manage Seats]

    var v_SelectedUserTier=""

Return

If(((v_Sum_Curr_Prd_Diff_Mg_Seats =0) ) ,"0 Users",

If(((v_Sum_Curr_Prd_Diff_Mg_Seats >=0 && (v_Sum_Curr_Prd_Diff_Mg_Seats <=5)) ) ,

    "1-5 Users"

,

If(((v_Sum_Curr_Prd_Diff_Mg_Seats >=6 && (v_Sum_Curr_Prd_Diff_Mg_Seats <=15)) ) ,

"6-15 Users"

,

If(((v_Sum_Curr_Prd_Diff_Mg_Seats >=16 && (v_Sum_Curr_Prd_Diff_Mg_Seats <=30))  ) ,

"16-30 Users"

,

If(((v_Sum_Curr_Prd_Diff_Mg_Seats >=31 && (v_Sum_Curr_Prd_Diff_Mg_Seats <=55)) ) ,

"31-55 Users"

,

If(((v_Sum_Curr_Prd_Diff_Mg_Seats >=56 && (v_Sum_Curr_Prd_Diff_Mg_Seats <=100))  ) ,

"56-100 Users"

,

If(((v_Sum_Curr_Prd_Diff_Mg_Seats >=101 )) ,

"100+ users"

,

"Users Unknown")

))))))

[Ashish_Mathur]

Hi,

Share some data, describe the business context/question and show the expected result.

[amitchandak · Accepted solution]

@Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example?

Are you looking for segmentation/bucketing of measure?

https://www.youtube.com/watch?v=CuczXPj0N-k
Appreciate your Kudos.

[Anonymous]

@amitchandakIn your video may i ask how is the Margin Bucket table linked to the other tables? Or is it unlinked?  

Secondly in the MarginBucket Measure the min and max are just place holders i am assuming to summarize? They would not refer to the min and max for the whole table but for each row?

[Anonymous]

Your video helped. Thank you! 

[Anonymous]

HI Amit,

Yes, Sort of segmentation.

I can acheive the same thing via a filter value. But i would prefet the text to be a part of the table itself.