Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Anonymous ,
Try the below measure:
@Anonymous , Try like
if(selectedvalue(Table[Parameter]="A"),Average(Table[Value]),calculate(Average(Table[Value]),Table[Parameter]="B"))
@Anonymous , Try like
if(selectedvalue(Table[Parameter]="A"),Average(Table[Value]),calculate(Average(Table[Value]),Table[Parameter]="B"))
@Anonymous ,
Try the below measure:
@Anonymous ,
For your convience I have uploaded PBIX file.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |