March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
27 | |
18 | |
16 | |
12 | |
11 |
User | Count |
---|---|
38 | |
29 | |
28 | |
20 | |
18 |