Forum Discussion

AntoineOA's avatar
AntoineOA
Frequent Visitor
3 years ago

Populate table and graph depending custom filters

Hello, I am facing an issue here. 

I want to create a custom slicer to allow my end user to choose between different income levels. My income is based on a measure. I created a custom filter with a manually added table that looks like this :  
I use the "measure" column as my slicer value. I want that when my user clicks on one of the choices of the slicer that my table returns my clients having an ARR in agreement with the choice of the slicer. My income are calculated with ethe following measure :  

 

ARR = SUM(CONTRACT_ALLMRR[total_mrr_EUR])*12.

 

I created another measure to return the values according to the choice but it just returns true or false and it doesn't only display my clients according to their ARR. The code of my measure is : 

 

Slicer Selection = 
VAR Selection =
    SELECTEDVALUE ( 'Table'[Measure] )
RETURN
    SWITCH (
        TRUE (),
        Selection = "<50K",CONTRACT_ALLMRR[ARR] < 50000,
        Selection = ">50K & <100K", CONTRACT_ALLMRR[ARR] > 50000 && CONTRACT_ALLMRR[ARR] < 100000,
        Selection = ">100K & <200K",  CONTRACT_ALLMRR[ARR] > 100000 && CONTRACT_ALLMRR[ARR] < 200000,
        Selection = ">200K", CONTRACT_ALLMRR[ARR] > 200000
        )


Here is the result in my table : 

How can I get only the clients depending of my slicer choice?

 

Need Help

3 Replies

  • PickleBear's avatar
    PickleBear
    New Member
    3 years ago

    Have you tried creating an extra column in your Customer table to Categorise each customer into one of these groups?  e.g. '<50k'.

     

    Then you can just join your Slicer table to your Customer table using the matching field.

    • AntoineOA's avatar
      AntoineOA
      Frequent Visitor
      3 years ago

      My problem here is that my ARR is calculated on the whole column and when I use it I add a filter on the dashboard to get the last calendar month. So based on your solution, I should create a columns and calculate my ARR for each month value I have for each client?

      • PickleBear's avatar
        PickleBear
        New Member
        3 years ago

        If it's only the last month you need for this data then you could create a summarised table by Customer, Last Month ARR, and Category