Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi community I have this Tableau Code In which we use COUNTD and INCLUDE. I am unable to convert this function into Power bi.
I shall be very thankful for any help.
Thanks in Advance.
IF COUNTD([Area Upper]) > 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
@Usman6400 , I have explained include LOD here, see if that can help
LOD Include (Level Of Details): https://youtu.be/nmBVc2fN6aU
exclude: https://www.youtube.com/watch?v=wJEjG3O3vrk
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.