topic Re: QUERY in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3435579#M130348 <P>i create one measure and its value not changes according to single selection of year. when i used two years at a time then only its value changes. and i want to changes value according to single selection of year. how to solve this?</P><P>&nbsp;</P> Mon, 18 Sep 2023 07:55:20 GMT Satya2277 2023-09-18T07:55:20Z QUERY https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3435556#M130345 <P>i create one measure and i used it in table. when i apply year filter on it using slicer, when i select one year then according to that table values gives zero value but when i used two years at a time then according to that table values changes. how to solve this issue?</P> Mon, 18 Sep 2023 07:42:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3435556#M130345 Satya2277 2023-09-18T07:42:41Z Re: QUERY https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3435570#M130347 <P>Elaborate on the issue.</P><P>&nbsp;</P> Mon, 18 Sep 2023 07:49:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3435570#M130347 ChiragGarg2512 2023-09-18T07:49:52Z Re: QUERY https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3435579#M130348 <P>i create one measure and its value not changes according to single selection of year. when i used two years at a time then only its value changes. and i want to changes value according to single selection of year. how to solve this?</P><P>&nbsp;</P> Mon, 18 Sep 2023 07:55:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3435579#M130348 Satya2277 2023-09-18T07:55:20Z Re: QUERY https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3435582#M130349 <P>Change slicer settings in format visual.</P> Mon, 18 Sep 2023 07:58:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3435582#M130349 ChiragGarg2512 2023-09-18T07:58:38Z Re: QUERY https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3435584#M130350 <P>i tried it.. but still facing same issue</P> Mon, 18 Sep 2023 07:59:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3435584#M130350 Satya2277 2023-09-18T07:59:36Z Re: QUERY https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3435587#M130351 <P>post an image of the issue or share a sample dataset in tabular format.</P><P>&nbsp;</P> Mon, 18 Sep 2023 08:00:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3435587#M130351 ChiragGarg2512 2023-09-18T08:00:58Z Re: QUERY https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3436167#M130383 <P><img /><img /></P> Mon, 18 Sep 2023 12:37:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3436167#M130383 Satya2277 2023-09-18T12:37:54Z Re: QUERY https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3436177#M130384 <P>share sample data in tabular format.</P><P>&nbsp;</P> Mon, 18 Sep 2023 12:46:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/QUERY/m-p/3436177#M130384 ChiragGarg2512 2023-09-18T12:46:06Z