Forum Discussion
Anmolgan
Post Prodigy
Post ProdigyCustomer 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, ...
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!
v-kelly-msft
Community Support
Community Support
AnmolganPost Prodigy
Post Prodigyv-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
- v-kelly-msft
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!