DAX Filter
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?
Wanted to extract the individual components in side the category
I want my data to look like this. I can see the total values for all the Ingredient text. I am using this measure to extract the ingredient text. But when I apply this measure, I can see the total values only for Ingredient 1 text and not for others. And when I use this measure as a tooltip, it is not working. Only ingredient 1 text is working Only ingredient 1 total value comes on the column and only that is working when used as a tooltip. Rest of the 3 ingredients shows a blank text. I am working on this as part of Week 35, 2021 #WorkoutWednesday https://workout-wednesday.com/pbi-2021-w35/ Kindly help me out
