Forum Discussion

Anmolgan's avatar
Anmolgan
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Customer Population grouping not working?

I want to group the customers as per there sum of the volumes, I am trying to get the below measure to work I had both tried custom column and measure but the below measure is not working out to be, ...
Need Help
Show and Tell
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anmolganļ¼Œ

     

    1.Create a slicer table with all the categories in the column:

    2.Create a measure as below:

     

    check = 
IF(SELECTEDVALUE('Slicer table'[Column1])='ZSD_MAT_MARGIN'[Customer Classification 1],1,0)

     

    3.finally put the measure in the table visual  and select measure =1.

     

    For the related .pbix file,pls click here.

     

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

Anmolgan's avatar
Anmolgan
Icon for Post Prodigy rankPost Prodigy
6 years ago

That is a custom column that I have calculated, but how can I use the overall built measure inside the powerbi?

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anmolgan 

šŸ™‚

your new column should aggregated data from your custom column?

show, please, example both of your data and desired result?

  • Anmolgan's avatar
    Anmolgan
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    az38  here is the link: https://ifitech-my.sharepoint.com/:u:/g/personal/anmol_ganju_ifi_tech/EUjEXdktSClOrR_MzMAj3rABuCCRWR2tqAfZBz_-0XnXYA?e=kt3MCe

     

     

    Check the ZSD MAT MARGIN table, measure created is Customer Classification 1 , desired output is been built in the page called "Segment/Sub-Segment Volume/Customer Population" check the table visual there, I just need to add that Customer Classification measure in my slider so thaat I can use the slabs to filter out 0-20 KL etc.

    • v-kelly-msft's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi  Anmolgan ,

       

      Just put the calculated column "Customer Population" in the slicer,and you will see:

       

       

      I have modified your .pbix file,pls click here.

       

      Best Regards,
      Kelly
      Did I answer your question? Mark my post as a solution!
      • Anmolgan's avatar
        Anmolgan
        Icon for Post Prodigy rankPost Prodigy
        6 years ago

        v-kelly-msft Hi, customer population is a custom column and that is not aligning correctly with the measure that I had built, you can see it for yourself, 0-20 KL slab is not aligning correctly with the custom column filter