Forum Discussion
Post ProdigyCustomer Population grouping not working?
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,
KellyDid I answer your question? Mark my post as a solution!
Post Prodigyaz38 Hi this is working as required inside the measure, but the problem is this is not working when I take it inside the slider, how can I work this out using the slider option.
Community Champion- Anmolgan
That is a custom column that I have calculated, but how can I use the overall built measure inside the powerbi?
- az38
🙂
your new column should aggregated data from your custom column?
show, please, example both of your data and desired result?
- Anmolgan
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.