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.

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

Greg_Deckler I've edited original post trying to be clearer.

 

No relationships between two tables

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
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.

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

     

    Greg_Deckler

     

    I was trying to make the report more configurable adding a filter by date column which is in Table1: changing date selection in the filter I'd like to have the updated values in the calculated column of Table2: how can I achieve this goal? I need a measure, right?

     

    Thanks a lot