DAX Filter

eag24 — Wed, 20 Mar 2024 13:53:48 GMT

Hello,

I am making a Price Volume Mix in PowerBI, but after review I need to fix my values for Total Volume. I have made this PVM Dynamic by allowing the user to select two years. I set those years as Min and Max. My table counts the volume of a product line for the minimum and maximum years selected perfectly fine, but I cant get the total volume of all productlines for each manufacturer of the seleted year. I could be overcomplicating it, but not sure. My first DAX VolumeYearMin for product line looks like this, and displays correct values.

VolumeYearMin =

VAR YearMin =

YEAR(MIN(CalendarTable[Date]))

RETURN

CALCULATE(

SUM(Table1[QUANTITY_SHIPPED]),

Table1[Year] = YearMin

)

My second dax where I want to grab all the manufacturer's volume for that product line runs of that yea. Displays the exact value of my first dax.

SumVolumeMin =

VAR YearMin =

YEAR(MIN(CalendarTable[Date]))

RETURN

CALCULATE(

SUMX(

FILTER(

Table1,

Table1[MANUFACTURER] = SELECTEDVALUE(Table1[MANUFACTURER]) &&

YEAR(Table1[INVOICE_DATE]) = YearMin

Table1[QUANTITY_SHIPPED]

)

Any Suggestions?

Re: DAX Filter

govindarajan_d — Wed, 20 Mar 2024 15:46:29 GMT

Hi eag24,

In your second DAX, I have few questions:

1. You are trying to show the selected manufacturer's volume?

2. Any reason why you enclosed it within CALCULATE? Did you check the same measure without using CALCULATE?

topic Re: DAX Filter in DAX Commands and Tips

DAX Filter

Re: DAX Filter