https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-HASONEVALUE/m-p/2130905#M48895 <P>when you selected two locations, in the filter context of card visual there are two values then it got a zero.</P> <P>but in the bar visual, each bar represents one location, so it always has one value.</P> Wed, 13 Oct 2021 01:27:57 GMT wdx223_Daniel 2021-10-13T01:27:57Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-HASONEVALUE/m-p/2130607#M48891 <P>Hi,</P><P>&nbsp;</P><P>Am new to Power BI. I am having really tough time understaing some DAX functions like HASONEVALUE.&nbsp;</P><P>I am attempting to use this function like below:</P><P>&nbsp;</P><P><img /></P><P>I have choosed 2 location and still I can see the Bar graph but the card shows zero. Why is it not working for the bar graph? My understanding is that, if you choose 2 options in slicer, essentially it should not work. Please suggest. My DAX is:</P><DIV><DIV><SPAN>Hasonevalue 1 = IF(HASONEVALUE(data[Location]), SUM(data[Sales Amount]),0)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P><P>Regards,</P><P>Sid</P></DIV></DIV> Tue, 12 Oct 2021 20:24:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-HASONEVALUE/m-p/2130607#M48891 SDVN 2021-10-12T20:24:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-HASONEVALUE/m-p/2130905#M48895 <P>when you selected two locations, in the filter context of card visual there are two values then it got a zero.</P> <P>but in the bar visual, each bar represents one location, so it always has one value.</P> Wed, 13 Oct 2021 01:27:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-HASONEVALUE/m-p/2130905#M48895 wdx223_Daniel 2021-10-13T01:27:57Z