topic Re: Line values is not correct with the if dax from slicer value in DAX Commands and Tips

Line values is not correct with the if dax from slicer value

Anonymous — Thu, 24 Feb 2022 09:36:20 GMT

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

Select Fund Type = selectedvalue('Fund Type'[Fund Type],"NF") is displaying correctly and the Avg card is display correctly.

However assigning the Avg to the line is always evaluating to 20

Avg = if(selectedvalue('Fund Type'[Fund Type],"NF") = "NF",50000,200)

This is a snapshot when no Fund Type Industry is selected and the Avg card is showing 50K but the Avg in the chart is showing 200 . It is always showing 200 in the chart irregardless of the value in the Avg card.

Re: Line values is not correct with the if dax from slicer value

Russell-PBI — Thu, 24 Feb 2022 09:59:39 GMT

Hi Anonymous, you have Fund Type as your legend, which might be stopping your measure from evaluating as TRUE.

Re: Line values is not correct with the if dax from slicer value

Anonymous — Thu, 24 Feb 2022 10:05:27 GMT

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.

Re: Line values is not correct with the if dax from slicer value

Anonymous — Thu, 24 Feb 2022 10:40:15 GMT

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

Re: Line values is not correct with the if dax from slicer value

Russell-PBI — Thu, 24 Feb 2022 14:21:20 GMT

Hi Anonymous, does this work?:

Avg = IF( CALCULATE( DISTINCTCOUNT('Fund Type'[Fund Type]) , ALLSELECTED('Fund Type'[Fund Type]) ) > 1 , 50000 , 200 )

Re: Line values is not correct with the if dax from slicer value

Anonymous — Thu, 24 Feb 2022 21:43:07 GMT

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

Re: Line values is not correct with the if dax from slicer value

Anonymous — Mon, 28 Feb 2022 06:52:22 GMT

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