Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
User | Count |
---|---|
20 | |
18 | |
17 | |
11 | |
7 |
User | Count |
---|---|
28 | |
28 | |
13 | |
12 | |
12 |