Forum Discussion
Helper IVDAX expression, need suggestion
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.
Community ChampionNot really following this. Sample data that can be copied and pasted always helps. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490. What is the relationship between those two tables?
Helper IV- Greg_Deckler
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
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