Represent column value in a card

[Anonymous]

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              78

24/6         B              82

25/6         A              89

26/6         B              76

Case1: 

If user selects date as 24/6, print 78 on a card, if parameter == A, else 82

Case2 

If user selects date as 25/6, print 89 on a card,  if parameter == A, else 76

Case 3:

If user selects both dates, then print the average(83.5 in this case) on the card, else average of B parameter corresponding values

Thanks in advance

[Tahreem24 · Accepted solution]

@Anonymous ,

Try the below measure:

Measure =  CALCULATE(AVERAGE(Sheet6[Value]),ALLEXCEPT(Sheet6,Sheet6[Parameter],Sheet6[Date]))

[amitchandak · Accepted solution]

@Anonymous , Try like

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

[Tahreem24 · Accepted solution]

@Anonymous ,

Try the below measure:

Measure =  CALCULATE(AVERAGE(Sheet6[Value]),ALLEXCEPT(Sheet6,Sheet6[Parameter],Sheet6[Date]))

[Tahreem24]

@Anonymous ,

For your convience I have uploaded PBIX file.