Forum Discussion
Getting % when selecting a Filter within Power BI
Hello BI Community, I have a power BI sheet which has different options of filters. I want to know formula of total lines in report divided by choosen filter. Example, I have Open Order Report ...
Hi!
To pass the selected filter to the metric you can use the SELECTEDVALUE function. It would look like this:
Rows STATUS = CALCULATE(COUNTROWS(Fact_Table),Orders[Status]=SELECTEDVALUE(Orders[Status]))
I tried and it did not work. Let me explain a more details. I have several slicers.
1) Report Date slicer = I choose in this filter report one file or many to get data
2) Entity Slicer = I then choose one or many entity which I want review t
3) The next steps I choose as needed and its where I want to see % of amount of lines open in entity vs info below.
- IF I choose Accouting Status Slicer = I want to see % which are on HD status or not.
- IF I decide to choose past due instead of Accounting slicer = I want to see % which are past due.
Keep mind % is based on total in Entity.