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 ...
Hello
I have filter one with HD checkbox and other with NO HD checkbox. I used this formula and it works when I check NO HD regarding percentage but does not work when I check HD. I first got amount of lines on HD status and then try to get %. When I click on HD the % was given me 100% which is not accurate.
formula 1) Rows HOLD STATUS = CALCULATE(COUNTROWS('Open orders - AMERICAS'),'Open orders - AMERICAS'[Accounting status] ="HD")
formula 2) % Rows on HOLD STATUS = DIVIDE([Rows HOLD STATUS],(DISTINCTCOUNT('Open orders - AMERICAS'[Sales Order + Souriau Line ])),0)
In addition beside of case above, is there a way to get % when I select data from specific table related to what I click when an option within a filter.
example: I have table called Analysis code and within this table I choose "Pending". I want to get % of what is pending for total amount under table called analysis code which have pending and may others words.