Display result based on selected Category

[kilala]

Hi all,

In my fact table, I have Status Column which contains below:

- Open

- Partially Matched

- Matched

- Closed

I have created 5 status category using Shape as below:

Under the shapes, there would be a table. If user select "All Status", it will display all result from the table. If user click Open, it will only show records where Status = Open. 

How do I create measure for this?

Thank you.

[ghoshabhijeet]

@kilalaYou can use slicer instead of shapes to filter values. Also, you can skip "ALL STATUS" in the filter value if it's not required at all, since unselecting any slicer value will automatically show all data.

Presuming you will doing some calculation since your data is in fact table, I have created a sample data to answer your question. Please find below:

Data:

Showing sum of all values when no filter is selected:

Showing only values for Open status:

DAX measure used for this calculation:

Show data based on category =

IF (

SELECTEDVALUE ( Sheet1[Status] ) = "",

CALCULATE ( SUM ( Sheet1[Val] ), ALL ( Sheet1 ) ),

CALCULATE (

SUM ( Sheet1[Val] ),

FILTER ( Sheet1, Sheet1[Status] = SELECTEDVALUE ( Sheet1[Status] ) )

)

)

---------------------------------------------------------------------------------
** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search. Thank you !

[amitchandak · Accepted solution]

@kilala , if these are row values of a column, You can create a slicer with select all. And the Choose orientation as horizontal https://docs.microsoft.com/en-us/power-bi/power-bi-slicer-filter-responsive