Measure to Column Conversion

[Akhil_1411]

Hi All😊

I am trying this from one week but not getting appropriate results.😥

I wanted to convert measure to a column since end user wanted to use as a slicer. In my report i need to show four slicer with different metrics. 

Below is the one of the measure i would like to convert into column.

UCD % Measure = DIVIDE(SUM(rawdata[Unearned Disc]),SUM(rawdata[Total_disc]))

Attached is the screenshot of the requirement and power bi file . Link: https://we.tl/t-RqzYlVkEoo

Thanks,

Akhil.

[Akhil_1411]

Hi @Ashish_Mathur  @Fowmy 

Thanks for looking. We almost got ter.

Actaully, i am not using the % ucd in any of the visual in the report. The reports consists of different metrics built on different visuals ( approx: 17 visuals on a report ).

Now the question is how can i account this logic which u have given for all the different metrics and the visuals?

Thanks,

Akhil.

[Ashish_Mathur]

Hi,

You will have to edit/rewrite all your measures.

[Fowmy]

@Akhil_1411 

Check how the measure that I created to work as per selection from the slicer and modify all your existing measures with same logic. 

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[amitchandak]

@Akhil_1411 , You can create a column like this

UCD % Measure = DIVIDE(rawdata[Unearned Disc],rawdata[Total_disc])

But use only for creation bucket. Because your calculation for UCD % is correct.

[Ashish_Mathur]

Hi,

Creating a calculated column formula will not be a good idea simply because those formulas do not update when a user changes a slicer setting.  If you are willing to see your measure in a slicer with bands such as 0-25%, 25.1%-50%, then share those bands with me.  Share a 3 column table - lower limit, Upper limit and the "text as it should appear in the slicer".

[Akhil_1411]

@Ashish_Mathur ,

Thanks for your reply. Ya, i know.

Okay. Below is my range criteria that to be used in the slicer and that needs to dynamically change with the other slicer changes.

Criteria	Lower Limit	Upper Limit
0 - 10	0	10
10-20	10	20
20-50	20	50
50-100	50	100

Thanks,

Akhil.

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[Fowmy]

@Akhil_1411 

I have added the range table and modified the measure to so when selecting a value from the range table, it will filter and show only the relevant records.

You can download the file: HERE

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn