Forum Discussion

JUSEGAPO's avatar
JUSEGAPO
Regular Visitor
9 years ago
Solved

¿How i can make calculation including filters?

Hi everyone,   Im new on it platform, i was working on Qlik platforms but in this moment we need to use Power BI.    I need to calculate percetage of execution, so i have it information:   N...
General Comment
Need Help
Tips and Tricks
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi JUSEGAPO

     

    You can do it with the following measures below. 

    NOTE: My table is named 'Table1'

     

    Tickets = COUNTROWS('Table1')

Tickets Closed = CALCULATE([Tickets],'Table1'[Estado] = "Closed")

Tickets Closed % = DIVIDE([Tickets Closed],[Tickets])

    I then put in a slicer for Proyecto and I got the following result when slicing on Project1

     

     

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

Hi JUSEGAPO

 

You can do it with the following measures below. 

NOTE: My table is named 'Table1'

 

Tickets = COUNTROWS('Table1')

Tickets Closed = CALCULATE([Tickets],'Table1'[Estado] = "Closed")

Tickets Closed % = DIVIDE([Tickets Closed],[Tickets])

I then put in a slicer for Proyecto and I got the following result when slicing on Project1

 

 

  • JUSEGAPO's avatar
    JUSEGAPO
    Regular Visitor
    9 years ago

    Hi GilbertQ,

     

    Thanks a lot!!! It works.

     

    Can you explain me how i can make more than 1 filter in the same formula? For example, make filter in "Estado" with "Closed" and "Finish"?

     

     

    Thanks in advance.

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      9 years ago

      Sure not a problem at all.

       

      To have multiple conditions you can modify it as shown below from the Original Measure

       

       

      Tickets Closed = CALCULATE([Tickets],'Table1'[Estado] = "Closed" && [Tickets],'Table1'[Estado] = "Finish")

      The && represents and, so it is saying where tickets are "Closed and Finish"

       

      If you want to use OR then use the || which will then say tickets are "Closed or Finish"