Forum Discussion

h11's avatar
h11
Icon for Helper III rankHelper III
2 years ago
Solved

Have a table Appear only few values when a filter is selected

Hello Team,   I have a question about filtering the data. I have two columns 1. Name, 2. Status. Initially I would like to show the status of all the names (Approved, In process and Completed) data...
Need Help
  • ExcelMonke's avatar
    ExcelMonke
    2 years ago

    You're welcome! If this is helpful, please mark it as a solution 🤠 
    In order to get what you need, you will need to do the following:

    1. In modeling, create a new table with the following DAX:

     

     

    VALUES(Table[Name])​

     

    And add this new column to a slicer on the page

     

    • Create a measure with the following:

     

     

    Measure = 
VAR _SelectedValue = SELECTEDVALUE('Table 2'[Name])
VAR _Filtered = CALCULATE(DISTINCTCOUNT('Table'[Name]),FILTER('Table','Table'[Status] IN {"Approved", "In Progress"} && 'Table'[Name]=_SelectedValue)))
VAR _All = CALCULATE(DISTINCTCOUNT('Table'[Name]))

RETURN
IF(ISBLANK(_SelectedValue),_All,_Filtered)​

     

     

    • Lastly, on your table, add the measure filter to the visual filter pane and mark the filter as "is not blank"

    You should get this as result:

    Filtered: 

     

     

h11's avatar
h11
Icon for Helper III rankHelper III
2 years ago

parry2k Thank you for the response. But that is not my question. If I use a page - level filter, I should manually select the status whenever I want to see a set of statuses. I can still do that on my desktop for myself. But if I publish the file and people go through that file in a workspace. I want them to see the initial data as shown in screenshot 1 and then, by selecting their name, the approved and in process status data should automatically be shown instead of manually clicking on the filters to get the required data.