Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Using Measure as a Slicer Question

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?  
 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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?)