Now close two brackets and hit enter key to get the total.Īs you can see above since we have edited the existing formula we have sales value only for the city “Texas” and for the year “2015”.For this column we need only “Texas” state sales total for the year 2015, so put an equal sign and enter the criteria as Texas.Filter Expression that we need to apply for the column is “State” so choose the “State” column.The next option of the CALCULATE function is Filter 2 so for this open another FILTER function.Now imagine a situation where you need to apply multiple filters, for an example we have already created filter for the year 2015, now let’s say we need to have these sales total only for the state “Texas” in this case we can continue the old formula and after applying FILTER put comma to access next argument of CALCULATE function.This will give visualization as shown below.2015 Year Sales to the table visual to get the year 2015 total for each city. Close two brackets and hit enter key to get the sales value for the year 2015 only.
Power bi desktop login download#
So you can download the excel workbook from the below link which is used for this example. Power BI Filter – Example #1įor demonstrating the Filter function consider the below data table that we are going to use. Let’s see some of the examples to understand the functionality of the Filter DAX function in Power BI.
Power bi desktop login how to#
How to Use Filter DAX Function in Power BI? In case of filtering individual city sales we need to select a city column and by putting equal sign we need to enter the city name in double-quotes.