Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Represent column value in a card

Dear team,    Please help me with the following problem scenario:   I want to print the value of a parameter in such a way: Sample Data   Date     Parameter   Value  24/6         A           ...
Need Help
Show and Tell
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    Anonymous ,

    Try the below measure:

    Measure =  CALCULATE(AVERAGE(Sheet6[Value]),ALLEXCEPT(Sheet6,Sheet6[Parameter],Sheet6[Date]))
     
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Try like

    if(selectedvalue(Table[Parameter]="A"),Average(Table[Value]),calculate(Average(Table[Value]),Table[Parameter]="B"))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try like

if(selectedvalue(Table[Parameter]="A"),Average(Table[Value]),calculate(Average(Table[Value]),Table[Parameter]="B"))