Dynamic Data Segmentation
First off, I've reviewed the various posts by RADACAD, Enterprise DNA and SQLBI on this topic. I have measures based on RADACAD & SQLBI all working, but its not giving me what I need/want. I don't know why I can't wrap my head around this. All I need is basic catorgization of my data. All of the examples are based upon financial or performance analysis. I just need to be able to filter a list to say 'here are all the rows that meet the criteria of X segement'. Specifically I have data that reprsents how often PDFs are generated from various Report Tempalates; frequency of creation. I have measure [Count Runs] that calculates how often each report has been run over time. I just want to dynamically drop each report (row) into a bucket to segement the data based on how often each report was run. Can anyone point me to existing documention that may aid me? If not I can post a sample data model, etc. but was hoping to avoid that. #FrustratingFriday
Help with DAX on running total
Hi So i got two measures that show the actual count per product and another that show the cumulative count per product: What i need is a DAX formula that shows the Inventory RT data for all lines that are representing the product cumulative subtotals and the RevenueDataAllLines data for lines named Inventory in and Units sold. The formula for RevenueDataAllLines is =sum(RevenueInputsDatabase[Value]) The formula for Inventory RT is =VAR LastVisibleDate = MAX ( BudgetCalendar[Date] ) VAR FirstVisibleDate = MIN ( BudgetCalendar[Date] ) VAR LastDateWithSales = CALCULATE ( MAX ( RevenueInputsDatabase[Transaction Date] ), ALL(RevenueInputsDatabase) ) VAR Result = IF ( FirstVisibleDate <= LastDateWithSales, CALCULATE ( [RevenueDataAllLines], BudgetCalendar[Date]<= LastVisibleDate ) ) RETURN Result Below is the result that should be displayed: Thanks in advance!
