https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax/m-p/4253763#M168497 <P>Based on the quater selection dynamically comments also need to change,if select all quater it's shows Quater 3 comments how to write Dax condition&nbsp;</P> Wed, 23 Oct 2024 07:21:54 GMT Praveen0303 2024-10-23T07:21:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax/m-p/4253763#M168497 <P>Based on the quater selection dynamically comments also need to change,if select all quater it's shows Quater 3 comments how to write Dax condition&nbsp;</P> Wed, 23 Oct 2024 07:21:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax/m-p/4253763#M168497 Praveen0303 2024-10-23T07:21:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax/m-p/4253964#M168503 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="829449" data-lia-user-login="Praveen0303" class="lia-mention lia-mention-user">Praveen0303</a>&nbsp;,</P> <P>&nbsp;</P> <P>try to plot a visual with a measure like this:</P> <P>&nbsp;</P> <LI-CODE lang="markup">Measure = IF( COUNTROWS(VALUES(data[Qtr]))=COUNTROWS(ALL(data[Qtr])), MAXX(FILTER(data, data[Qtr]="Q3"), data[Comments]), MAX(data[Comments]) )</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>it worked like:</P> <P><img /></P> <P>&nbsp;</P> Wed, 23 Oct 2024 08:43:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax/m-p/4253964#M168503 FreemanZ 2024-10-23T08:43:35Z