Forum Discussion

Akhil_1411's avatar
Akhil_1411
Helper IV
6 years ago

Measure to Column Conversion

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.
General Comment
Need Help
Show and Tell

8 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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's avatar
    Ashish_Mathur
    Super User
    6 years ago

    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's avatar
      Akhil_1411
      Helper IV
      6 years ago

      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.

       

      CriteriaLower LimitUpper Limit
      0 - 10010
      10-201020
      20-502050
      50-10050100

       

      Thanks,

      Akhil.

      • Fowmy's avatar
        Fowmy
        Super User
        6 years ago

        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

         




  • Akhil_1411's avatar
    Akhil_1411
    Helper IV
    6 years ago

    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.

    • Fowmy's avatar
      Fowmy
      Super User
      6 years ago

      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