Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
User | Count |
---|---|
20 | |
14 | |
11 | |
9 | |
6 |
User | Count |
---|---|
24 | |
23 | |
20 | |
15 | |
10 |