powerbireportpowerquery
Filter with DAX in power BI
I am trying to filter with a DAX measure in power BI. I have a list of countries by in my DAX formula I want to return United Kingdom and France
Country
United Kingdom
France
Germany
Turkey
South Africa
Ghana
Nigeria
Australia
New Zealand
Fiji
Solomon Islands
Canada
United States
India
Mexico
Brazil
China
My DAX is
ListCountry = CALCULATE(MAX(Orders[Country]),FILTER(Orders,Orders[Country]="France" || Orders[Country] ="United Kingdom"))
When I test it it returned only United Kingdom
BUT what I want is display
United Kingdom
France
Solution
It returns only United Kingdom, because you are calculating the MAX value (MAX(Orders[Country])). In this case, the filter returns France and United Kingdom, and the later one is the maximum value. Otherwise the filter returns what you expect:
Table = FILTER(Orders, Orders[Country] = "France" || Orders[Country] = "United Kingdom")
- Is there a workaround for Power BI Desktop to automatically refresh data without publishing pbix to Power BI Service?
- DAX function for highlights latest value in each month
- PowerBI currently broken with BigQuery: Simba driver issue with windows update
- Writing a Power BI measure to check multiple records in a related table based on values in both tables
- Create custom columns and append to matrix
- Importing a variable CSV with Python and Power BI error
- Replace blank cells in matrix with 0
- Create dax query in query editor to split table into multiple tables
- DAX CALCULATETABLE/SUMMARIZE filter
- Diff date cumulated
- Import pdf files from API into rows in Power Bi
- Can legends in PowerBI Pie Chart be hidden if value is zero?
- Remove Alphanumeric string and following character from end of the string in power BI
- 'Exclude' slicer in Power BI
- Limiting a Slicer's Multi-Select Options by A Category
- Vega multi-line chart messed up by moving brushed area but works with fold
- Using a DAX Query to calculate a maximum value for each of my projects from two tables in a many to one relationship
- Pass a Terraform Output to an Azure DevOps Varibale
- load data into power BI from relative path
- Power BI Bacci's Gantt 2.0 - Center "Today" within viewport?
- PowerBI - Bug in function LOOKUPVALUE?
- Measure using PREVIOUSYEAR is returning BLANK on card visual but works on matrix
- how to append two columns in the same table in Power BI
- How to prevent Vega signals from resetting when changing Deneb input data via Power BI slicers
- Power BI - Unable to add icons to my table visual
- Power BI :: Calendar Table doesn't have the calendar icon
- Trying to calculate change over time using a SUMX function with DAX. but the value I get is cumulative value--how can I get the non-cumulative value?
- Data Refresh Time Estimate for Incremental Refresh without Query Folding
- How to leverage previous value in dax without yielding a circular dependency?
- How to decide between using the SharePoint folder vs web connector to access excel file?