Filter columns with a measure slicer.

[Varshi288]

Hi, I am classifying Customers based on their last year spending category groups like 0-5k, 50k-200k ...
with the measure. This is fine but when I add other measures extra customers are visible.
How to get the values of only customers who fall in the category groups. In the attached snapshot I should see only the last 2 customers rather than 4. Any inputs.

[v-chenwuz-msft · Accepted solution]

Hi @Varshi288 ,

Have you solved your problem?

If you do not want display items with no data, first , you should make sure un-select check-box of show items with no data. And then add if function in front of  other measure.

Measure_Add = if( ISBLANK([Measure]),blank(),SUM('Table'[Values1]))

--->>

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Varshi288]

@Greg_Deckler I am using this as a disconnected table only.

[Greg_Deckler]

@Varshi288 In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...