Using Measure as a Slicer Question

[Anonymous]

Hi Community,

I have been successfully using a measure as a slicer in the following scenario: 

Labor Revenue = SUM(LaborRevenue) 

Disconnected Table - RevSlicer:

Value: 0,1000,2500,5000

Slicer Measures:

Labor Revenue Selection= SELECTEDVALUE(RevSlicer[Value])

-- selects revenue values 0 through 5000 in a slicer 

Labor Revenue Filter = IF([Labor Revenue] > [RevSlicer[Value], 1, 0)

--use '1' as a table filter to filter my table based on selection - so execs can see measures for clients over specific revenue thresholds. 

This is displayed in a table with column values of Location, Customer, then a bunch of measures for each customer.

Works great except for the new request to build a second table for totals by Location with the same measures and slicer options.

Now that I am rolling up to total Location numbers instead of individual Customer, the "Labor Revenue" is no longer sub-5k ever and the slicer doesn't work.  How can I get this to iterate through by customer and perform the same function?  

[Icey]

Hi @Anonymous ,

It's best to share us some sample data or a dummy .pbix file for test. Please remove sensitive information.

Reference: How to provide sample data in the Power BI Forum

Best Regards,

Icey

[amitchandak]

@Anonymous , Have different measures there that work with the location.  use the same filter condition?

[Anonymous]

They all build upon the Labor Revenue Measure, it's the building block for all of the measures I have created (Primarily Rev-Cost for Margins, %GM, Rolling Margins, etc.)   (Does that answer the question?)