Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! Learn more
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
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 14 | |
| 11 | |
| 8 | |
| 5 | |
| 5 |