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.
Could someone help why the line value function is not working with the selectedvalue in the slicer.
Have a slicer Fund Type with the options below. Using a card with DAX
Solved! Go to Solution.
Hi @Anonymous, you have Fund Type as your legend, which might be stopping your measure from evaluating as TRUE.
Hi @Anonymous
I am so glad to hear that you have solved your problem , please consider Accept it as the solution to help the other members find it more quickly.
Best Regards
Community Support Team _ Ailsa Tao
It did not work unless the column series Fund Type is remove. Found a way around it where the slicer is at the Fund Type table ( containing a list of distinct values) and the coumn series is at the table row level. Thank you so much for your help
Needed to have column series of fund type and need to calculate the average in the line depending on the fund type selected. If none is selected then it is average of all fund types. Hope that clarify the context on the goal
Hi @Anonymous, does this work?:
Avg =
IF(
CALCULATE(
DISTINCTCOUNT('Fund Type'[Fund Type])
, ALLSELECTED('Fund Type'[Fund Type])
) > 1
, 50000
, 200
)
Needed the fund type in the column series to depict the different colour of the fund type. Is there a way to based only on selected value.
Hi @Anonymous, you have Fund Type as your legend, which might be stopping your measure from evaluating as TRUE.
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |