Forum Discussion

laciodrom_80's avatar
laciodrom_80
Icon for Helper IV rankHelper IV
7 years ago
Solved

DAX expression, need suggestion

Hi all,   I have theese two tables with no relationship:   Table1                                            Table2                                             I ...
Need Help
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    OK, here is what I am thinking in Table2:

     

    Column = 
VAR __low = IF([Index]=1,[MinMeasure],[MinMeasure]+([Index]-1)*[IntervalGapMeasure])
VAR __high= IF([Index]=15,[MaxMeasure],[MinMeasure]+[Index]*[IntervalGapMeasure])
RETURN
COUNTX(FILTER('Table1',[Value]>=__low && [Value]<=__high),[Scenario Number])

    May need tweaking but something along these lines I believe.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I'm also a little bit lost reading your post.

Can you provide sample data?