Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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.
Solved! Go to 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
@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:
---------------------------------------------------------------------------------
** 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 !
@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