https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Tableau-s-Include-function-in-Power-bi/m-p/2816172#M89312 <P>Hi community I have this Tableau Code In which we use COUNTD and INCLUDE. I am unable to convert this function into Power bi.<BR />I shall be very thankful for any help.<BR />Thanks in Advance.</P><LI-CODE lang="markup">IF COUNTD([Area Upper]) &gt; 1 THEN IF ISNULL(MIN({include [Area Upper]:sum([Nominator])})) THEN NULL ELSE IF ISNULL(MIN({include [Area Upper]:sum([Denominator])})) THEN MIN({include [Area Upper]:sum([Nominator])}) ELSE MIN({include [Area Upper]:sum([Nominator])}/{include [Area Upper]:sum([Denominator])}) END END ELSEIF COUNTD([Sub Zone]) = 1 THEN IF ISNULL(MIN({include [Sub Zone]:sum([Nominator])})) THEN NULL ELSE IF ISNULL(MIN({include [Sub Zone]:sum([Denominator])})) THEN MIN({include [Sub Zone]:sum([Nominator])}) ELSE MIN({include [Sub Zone]:sum([Nominator])}/{include [Sub Zone]:sum([Denominator])}) END END ELSEIF COUNTD([Zone]) = 1 THEN IF ISNULL(MIN({include [Sub Zone]:sum([Nominator])})) THEN NULL ELSE IF ISNULL(MIN({include [Sub Zone]:sum([Denominator])})) THEN MIN({include [Sub Zone]:sum([Nominator])}) ELSE MIN({include [Sub Zone]:sum([Nominator])}/{include [Sub Zone]:sum([Denominator])}) END END ELSEIF COUNTD([Area Upper (group)]) = 1 THEN IF ISNULL(MIN({include [Zone]:sum([Nominator])})) THEN NULL ELSE IF ISNULL(MIN({include [Zone]:sum([Denominator])})) THEN MIN({include [Zone]:sum([Nominator])}) ELSE MIN({include [Zone]:sum([Nominator])}/{include [Zone]:sum([Denominator])}) END //MIN({include [Zone]:sum([Nominator])}/{include [Zone]:sum([Denominator])}) END END</LI-CODE><P>&nbsp;</P> Tue, 04 Oct 2022 08:23:05 GMT Usman6400 2022-10-04T08:23:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Tableau-s-Include-function-in-Power-bi/m-p/2816172#M89312 <P>Hi community I have this Tableau Code In which we use COUNTD and INCLUDE. I am unable to convert this function into Power bi.<BR />I shall be very thankful for any help.<BR />Thanks in Advance.</P><LI-CODE lang="markup">IF COUNTD([Area Upper]) &gt; 1 THEN IF ISNULL(MIN({include [Area Upper]:sum([Nominator])})) THEN NULL ELSE IF ISNULL(MIN({include [Area Upper]:sum([Denominator])})) THEN MIN({include [Area Upper]:sum([Nominator])}) ELSE MIN({include [Area Upper]:sum([Nominator])}/{include [Area Upper]:sum([Denominator])}) END END ELSEIF COUNTD([Sub Zone]) = 1 THEN IF ISNULL(MIN({include [Sub Zone]:sum([Nominator])})) THEN NULL ELSE IF ISNULL(MIN({include [Sub Zone]:sum([Denominator])})) THEN MIN({include [Sub Zone]:sum([Nominator])}) ELSE MIN({include [Sub Zone]:sum([Nominator])}/{include [Sub Zone]:sum([Denominator])}) END END ELSEIF COUNTD([Zone]) = 1 THEN IF ISNULL(MIN({include [Sub Zone]:sum([Nominator])})) THEN NULL ELSE IF ISNULL(MIN({include [Sub Zone]:sum([Denominator])})) THEN MIN({include [Sub Zone]:sum([Nominator])}) ELSE MIN({include [Sub Zone]:sum([Nominator])}/{include [Sub Zone]:sum([Denominator])}) END END ELSEIF COUNTD([Area Upper (group)]) = 1 THEN IF ISNULL(MIN({include [Zone]:sum([Nominator])})) THEN NULL ELSE IF ISNULL(MIN({include [Zone]:sum([Denominator])})) THEN MIN({include [Zone]:sum([Nominator])}) ELSE MIN({include [Zone]:sum([Nominator])}/{include [Zone]:sum([Denominator])}) END //MIN({include [Zone]:sum([Nominator])}/{include [Zone]:sum([Denominator])}) END END</LI-CODE><P>&nbsp;</P> Tue, 04 Oct 2022 08:23:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Tableau-s-Include-function-in-Power-bi/m-p/2816172#M89312 Usman6400 2022-10-04T08:23:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Tableau-s-Include-function-in-Power-bi/m-p/2816451#M89325 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="437905" data-lia-user-login="Usman6400" class="lia-mention lia-mention-user">Usman6400</a> , I have explained include LOD here, see if that can help</P> <P>LOD Include (Level Of Details): <A href="https://youtu.be/nmBVc2fN6aU" target="_blank">https://youtu.be/nmBVc2fN6aU</A></P> <P>&nbsp;</P> <P>exclude: <A href="https://www.youtube.com/watch?v=wJEjG3O3vrk" target="_blank">https://www.youtube.com/watch?v=wJEjG3O3vrk</A></P> Tue, 04 Oct 2022 09:38:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Tableau-s-Include-function-in-Power-bi/m-p/2816451#M89325 amitchandak 2022-10-04T09:38:22Z