Forum Discussion

IF's avatar
IF
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Row value

Hi, I want to show the row value for each selection. the file is here: https://we.tl/t-LcWJHkuk62 If nothing is selected, the default value should be shown based on Value[Rel]=”V”. For example, if...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

     

    PlanTestExcel = if (isfiltered(CityTable)||ISFILTERED(RegionTable)||ISFILTERED(TownTable),sum(Main[Value1]),CALCULATE(sum(Main[Value1]),Main[Rel]="V"))

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

 

PlanTestExcel = if (isfiltered(CityTable)||ISFILTERED(RegionTable)||ISFILTERED(TownTable),sum(Main[Value1]),CALCULATE(sum(Main[Value1]),Main[Rel]="V"))