topic DAX IF and FILTER in order to add a Flagged Column in DAX Commands and Tips

DAX IF and FILTER in order to add a Flagged Column

RPATER — Wed, 19 May 2021 21:03:20 GMT

Hello,

I am trying to add a flagged column to my visual for any row that has a Wave = 1 and a Delivery Rate < .85(85%).

I have been trying to use IF and FILTER statements but have had no success. The values continue to be returned as a 1 for every row regardless of wave or Delivery Rate.

Any help would be greatly appreciated!

Examples of Formulas used:

Risk = if(Query1[Wave]=1 && [Delivery_Rate]<.85,1,0)

Risk =

var Risk = CALCULATE([Delivery_Rate],Query1[Wave]=1)

return

if(Risk<.85,1,0)

ClientName	BrandName	Wave	Sent	Delivered	Delivery_Rate
Client1	Brand1	1	1962	1840	94%
Client1	Brand1	1	934	767	82%
Client1	Brand1	1	920	747	81%
Client1	Brand1	1	2052	1992	97%
Client1	Brand1	2	1989	1939	97%
Client1	Brand1	2	1916	1799	94%
Client1	Brand1	2	857	752	88%
Client1	Brand1	2	824	721	88%
Client1	Brand1	3	1963	1908	97%
Client1	Brand1	3	1897	1770	93%
Client1	Brand1	3	846	740	87%
Client1	Brand1	3	788	686	87%
Client2	Brand2	1	35390	29522	83%
Client2	Brand2	1	35446	29667	84%
Client2	Brand2	2	32640	28862	88%
Client2	Brand2	2	32449	28690	88%

Thank You,

Ryan

Re: DAX IF and FILTER in order to add a Flagged Column

amitchandak — Thu, 20 May 2021 02:12:17 GMT

RPATER , Wave seems like a column and Delivery Rate like a measure

Try one of the two

Risk =
var Risk = CALCULATE([Delivery_Rate],filter(Query1, Query1[Wave]=1))
return
if(Risk<.85,1,0)

Risk =
var Risk = CALCULATE([Delivery_Rate],filter(Query1, Query1[Wave]=1))
return
CALCULATE(if(Risk<.85,1,0), values(Query1[ClientName]), , values(Query1[BrandName]))

Re: DAX IF and FILTER in order to add a Flagged Column

Jihwan_Kim — Thu, 20 May 2021 06:27:53 GMT

Hi, RPATER

Please try the below.

Risk =

IF ( SELECTEDVALUE ( Query1[Wave] ) = 1 && [Delivery_Rate] < .85, 1, 0 )

https://www.dropbox.com/s/cnumegm4hi7qu3r/rpater.pbix?dl=0

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM