topic Use of dynamic measures in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Use-of-dynamic-measures/m-p/3751435#M146321 <P><img /></P><P><STRONG>Measures</STRONG></P><DIV><DIV><SPAN>Count Cafe Coffee =</SPAN> <SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>Coffee</SPAN><SPAN>[Cafe Coffee]</SPAN><SPAN>)</SPAN></DIV><DIV><DIV><SPAN>Count Home Coffee =</SPAN> <SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>Coffee</SPAN><SPAN>[Home Coffee]</SPAN><SPAN>)</SPAN></DIV><DIV><DIV><SPAN>Count None of these Coffee =</SPAN> <SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>Coffee</SPAN><SPAN>[None of these]</SPAN><SPAN>)</SPAN></DIV><DIV><DIV><SPAN>Count Office Coffee =</SPAN> <SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>Coffee</SPAN><SPAN>[Office Coffee]</SPAN><SPAN>)</SPAN></DIV><DIV><DIV><SPAN>Count On-the-go Coffee =</SPAN> <SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>Coffee</SPAN><SPAN>[On-the-go Coffee]</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><STRONG>Dynamice Measure</STRONG></DIV><DIV><DIV><DIV><SPAN>Dynamic </SPAN><SPAN>Measure</SPAN><SPAN> Places =</SPAN></DIV><DIV><SPAN>SWITCH</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN> ( </SPAN><SPAN>'Select Places'</SPAN><SPAN>[Select Places]</SPAN><SPAN> ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"Home Coffee"</SPAN><SPAN>, </SPAN><SPAN>Coffee</SPAN><SPAN>[Count Home Coffee]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"Cafe Coffee"</SPAN><SPAN>,</SPAN><SPAN>Coffee</SPAN><SPAN>[Count Cafe Coffee]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"Office Coffee"</SPAN><SPAN>,</SPAN><SPAN>Coffee</SPAN><SPAN>[Count Office Coffee]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"On-the-go"</SPAN><SPAN>,</SPAN><SPAN>Coffee</SPAN><SPAN>[Count On-the-go Coffee]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"None Of these"</SPAN><SPAN>,</SPAN><SPAN>Coffee</SPAN><SPAN>[Count None of these Coffee]</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV></DIV><DIV><STRONG>Parameter</STRONG></DIV><DIV><DIV><SPAN>Select Places =</SPAN><SPAN> {</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; (</SPAN><SPAN>"Home Coffee"</SPAN><SPAN>, </SPAN><SPAN>NAMEOF</SPAN><SPAN>(</SPAN><SPAN>'Coffee'</SPAN><SPAN>[Count Home Coffee]</SPAN><SPAN>), </SPAN><SPAN>0</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; (</SPAN><SPAN>"Cafe Coffee"</SPAN><SPAN>, </SPAN><SPAN>NAMEOF</SPAN><SPAN>(</SPAN><SPAN>'Coffee'</SPAN><SPAN>[Count Cafe Coffee]</SPAN><SPAN>), </SPAN><SPAN>1</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; (</SPAN><SPAN>"Office Coffee"</SPAN><SPAN>, </SPAN><SPAN>NAMEOF</SPAN><SPAN>(</SPAN><SPAN>'Coffee'</SPAN><SPAN>[Count Office Coffee]</SPAN><SPAN>), </SPAN><SPAN>2</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; (</SPAN><SPAN>"On-the-go Coffee"</SPAN><SPAN>, </SPAN><SPAN>NAMEOF</SPAN><SPAN>(</SPAN><SPAN>'Coffee'</SPAN><SPAN>[Count On-the-go Coffee]</SPAN><SPAN>), </SPAN><SPAN>3</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; (</SPAN><SPAN>"None of these Coffee"</SPAN><SPAN>, </SPAN><SPAN>NAMEOF</SPAN><SPAN>(</SPAN><SPAN>'Coffee'</SPAN><SPAN>[Count None of these Coffee]</SPAN><SPAN>), </SPAN><SPAN>4</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>}</SPAN></DIV><DIV>I have created Individual measures-&gt;Dynamic Measures and created Parameter&nbsp;</DIV><DIV>when i select any of the places from the slicer it should display that particular chart only&nbsp;<BR />for instance when i select Home Coffee then it should Display the same chart of Home Coffee just as it is in the image; when i select Cafe Coffee it should Display the same chart of&nbsp;Cafe Coffee&nbsp;just as it is in the image and the same for the rest of the two<BR />in short one slicer one chart&nbsp;</DIV><DIV>i dont know how should i do it&nbsp;<BR />Can anyone help me with this query ?</DIV></DIV></DIV></DIV></DIV></DIV></DIV> Fri, 08 Mar 2024 13:09:49 GMT Anonymous 2024-03-08T13:09:49Z Use of dynamic measures https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Use-of-dynamic-measures/m-p/3751435#M146321 <P><img /></P><P><STRONG>Measures</STRONG></P><DIV><DIV><SPAN>Count Cafe Coffee =</SPAN> <SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>Coffee</SPAN><SPAN>[Cafe Coffee]</SPAN><SPAN>)</SPAN></DIV><DIV><DIV><SPAN>Count Home Coffee =</SPAN> <SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>Coffee</SPAN><SPAN>[Home Coffee]</SPAN><SPAN>)</SPAN></DIV><DIV><DIV><SPAN>Count None of these Coffee =</SPAN> <SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>Coffee</SPAN><SPAN>[None of these]</SPAN><SPAN>)</SPAN></DIV><DIV><DIV><SPAN>Count Office Coffee =</SPAN> <SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>Coffee</SPAN><SPAN>[Office Coffee]</SPAN><SPAN>)</SPAN></DIV><DIV><DIV><SPAN>Count On-the-go Coffee =</SPAN> <SPAN>COUNT</SPAN><SPAN>(</SPAN><SPAN>Coffee</SPAN><SPAN>[On-the-go Coffee]</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><STRONG>Dynamice Measure</STRONG></DIV><DIV><DIV><DIV><SPAN>Dynamic </SPAN><SPAN>Measure</SPAN><SPAN> Places =</SPAN></DIV><DIV><SPAN>SWITCH</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN> ( </SPAN><SPAN>'Select Places'</SPAN><SPAN>[Select Places]</SPAN><SPAN> ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"Home Coffee"</SPAN><SPAN>, </SPAN><SPAN>Coffee</SPAN><SPAN>[Count Home Coffee]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"Cafe Coffee"</SPAN><SPAN>,</SPAN><SPAN>Coffee</SPAN><SPAN>[Count Cafe Coffee]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"Office Coffee"</SPAN><SPAN>,</SPAN><SPAN>Coffee</SPAN><SPAN>[Count Office Coffee]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"On-the-go"</SPAN><SPAN>,</SPAN><SPAN>Coffee</SPAN><SPAN>[Count On-the-go Coffee]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"None Of these"</SPAN><SPAN>,</SPAN><SPAN>Coffee</SPAN><SPAN>[Count None of these Coffee]</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV></DIV><DIV><STRONG>Parameter</STRONG></DIV><DIV><DIV><SPAN>Select Places =</SPAN><SPAN> {</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; (</SPAN><SPAN>"Home Coffee"</SPAN><SPAN>, </SPAN><SPAN>NAMEOF</SPAN><SPAN>(</SPAN><SPAN>'Coffee'</SPAN><SPAN>[Count Home Coffee]</SPAN><SPAN>), </SPAN><SPAN>0</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; (</SPAN><SPAN>"Cafe Coffee"</SPAN><SPAN>, </SPAN><SPAN>NAMEOF</SPAN><SPAN>(</SPAN><SPAN>'Coffee'</SPAN><SPAN>[Count Cafe Coffee]</SPAN><SPAN>), </SPAN><SPAN>1</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; (</SPAN><SPAN>"Office Coffee"</SPAN><SPAN>, </SPAN><SPAN>NAMEOF</SPAN><SPAN>(</SPAN><SPAN>'Coffee'</SPAN><SPAN>[Count Office Coffee]</SPAN><SPAN>), </SPAN><SPAN>2</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; (</SPAN><SPAN>"On-the-go Coffee"</SPAN><SPAN>, </SPAN><SPAN>NAMEOF</SPAN><SPAN>(</SPAN><SPAN>'Coffee'</SPAN><SPAN>[Count On-the-go Coffee]</SPAN><SPAN>), </SPAN><SPAN>3</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; (</SPAN><SPAN>"None of these Coffee"</SPAN><SPAN>, </SPAN><SPAN>NAMEOF</SPAN><SPAN>(</SPAN><SPAN>'Coffee'</SPAN><SPAN>[Count None of these Coffee]</SPAN><SPAN>), </SPAN><SPAN>4</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>}</SPAN></DIV><DIV>I have created Individual measures-&gt;Dynamic Measures and created Parameter&nbsp;</DIV><DIV>when i select any of the places from the slicer it should display that particular chart only&nbsp;<BR />for instance when i select Home Coffee then it should Display the same chart of Home Coffee just as it is in the image; when i select Cafe Coffee it should Display the same chart of&nbsp;Cafe Coffee&nbsp;just as it is in the image and the same for the rest of the two<BR />in short one slicer one chart&nbsp;</DIV><DIV>i dont know how should i do it&nbsp;<BR />Can anyone help me with this query ?</DIV></DIV></DIV></DIV></DIV></DIV></DIV> Fri, 08 Mar 2024 13:09:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Use-of-dynamic-measures/m-p/3751435#M146321 Anonymous 2024-03-08T13:09:49Z Re: Use of dynamic measures https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Use-of-dynamic-measures/m-p/3752014#M146338 <P data-unlink="true">Hi&nbsp;Anonymous</LI-USER>&nbsp;check <A href="https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks?tabs=powerbi-desktop" target="_blank">link</A> for bookmarks and another <A href="https://www.youtube.com/watch?v=xCMqWEvSkAs" target="_blank">one&nbsp;</A></P> <P>&nbsp;</P> Fri, 08 Mar 2024 19:41:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Use-of-dynamic-measures/m-p/3752014#M146338 some_bih 2024-03-08T19:41:34Z Re: Use of dynamic measures https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Use-of-dynamic-measures/m-p/3752389#M146371 <P>thank so much&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="27615" data-lia-user-login="Som" class="lia-mention lia-mention-user">Som</a>e_bih for the solution&nbsp;<span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Sat, 09 Mar 2024 05:47:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Use-of-dynamic-measures/m-p/3752389#M146371 Anonymous 2024-03-09T05:47:08Z