Forum Discussion

Aguilucho24's avatar
Aguilucho24
Regular Visitor
3 years ago

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 ...
Need Help
Aguilucho24's avatar
Aguilucho24
Regular Visitor
3 years ago

Hello MarcosVin

Thanks for information....

 

Question, instead of choose a specific status such as HOLD. Is there opcion when I choose different slicer instead of only looking at HOLD. Example, in one moment I click on HOLD and gives me %. If then I decide to click on Past Due it give me %. The formula you provided only impacts slicer for HOLD STATUS.

 

Basically, trying to avoid to create for each slicer filter a formula.

  • marcosvin's avatar
    marcosvin
    Resolver II
    3 years ago

    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]))
    • Aguilucho24's avatar
      Aguilucho24
      Regular Visitor
      3 years ago

      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.