topic Filter data in a measure if either condition is met in DAX Commands and Tips

Filter data in a measure if either condition is met

MikeGeno — Thu, 28 Sep 2023 20:21:48 GMT

Very new to power BI. Getting my feet wet. I created the following measure to calculate a sales total from two different fact tables

RankedSales =

calculate(SUM(SalesData[Sales])) + CALCULATE(SUM('NCS Sales'[Sales]))

I have two other fields that that determine if the sales are to be included. If either of these are not the values below, they do not count for this measure.

Distributor[Include in Rankings?] = "Y"

Windfalls[Exclude Windfall?] = ""

Can I incorporate this into the measure? Thanks in advance

Re: Filter data in a measure if either condition is met

SQL_SousChef — Fri, 29 Sep 2023 03:11:59 GMT

As long as all of these tables are connected this should work:
RankedSales = CALCULATE( SUM(SalesData[Sales]) + SUM('NCS Sales'[Sales]), FILTER( ALL('Distributor', 'Windfalls'), 'Distributor'[Include in Rankings?] = "Y" && 'Windfalls'[Exclude Windfall?] = "" ) )

Re: Filter data in a measure if either condition is met

sjoerdvn — Fri, 29 Sep 2023 15:24:02 GMT

RankedSales = CALCULATE( SUM(SalesData[Sales]) + SUM('NCS Sales'[Sales]) ,Distributor[Include in Rankings?] = "Y" ,Windfalls[Exclude Windfall?] = "" )

Re: Filter data in a measure if either condition is met

MikeGeno — Wed, 04 Oct 2023 13:43:19 GMT

Thank you! This worked