DAX - Segmentation

[gavs73]

Hi I'd appreciate any help on the DAX Query below. I have two tables, the first called 'combined' and the second 'days', these are unlinked. I'd like to segment the Credit amounts in 'combined' by their Termination Days [TermDays] using the ranges I've created in 'days'.


DaysRange:=
CALCULATE (
combined[TermDays],
FILTER (VALUES(combined[Credit]),
COUNTROWS(
FILTER(
Days,
combined[TermDays] >= Days[Start]
&& combined[TermDays] < Days[End]
)>0))

 

[Matt Allington]

This is not really enough information to provide you with any help.

your calculate acts on what looks like a column "combined[termDays]" - that is not going to work as it doesn't do anything. Then you have 2 filters (nested). The inner most is comparing columns from 2 different tables, but there is no information about the initial filter context (if any) or if you are trying to write a calc column. To help, you really need to provide a sample workbook set up with an illustration of the result you are after