Creating a meassure with filters

[Anonymous]

Hi community i know this issue is an absurd but im not figuring how to create this meassure...

I need to create a meassure where it calculates the count of Envios but when Entregado = N and Rendido = S

Heres my SQL Server Query i want to put it in power bi measure...

How can i do it??

(select count(env.EnvioID) from envios env where env.Rendido = 'S' and env.Entregado = 'N' and Anulado = 0) as CompNoEntregados,

[Greg_Deckler]

If you can share sample/example data and your expected output, can be more specific. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.

In general, you can do something like:

Measure = SUMX(FILTER('envios',[Rendido] = "S" && [Entregado] = "N" && [Anulado] = 0),[Some Value])

[Anonymous]

The thing i need to achive is this!!

And its a count not a sum!!

Im trying to put all this values in a table with Power Bi (All the colums are generated by differents querys in SQL SERVER). So the thing i want to show now is the column "No Entregados" because i have a page filter where takes the status of Entregado = 'S' and Rendido = 'S' but know i need to know wich ones are Entregado = 'N' and Rendido = 'S'

Ty for the Reply!!!

[Greg_Deckler]

Well, if it is a count, then you use COUNTX instead of SUMX. If you are page filtering stuff out, you might need to use ALL. So perhaps something like this:

Measure = COUNTX(FILTER(ALL('envios'),[Rendido] = "S" && [Entregado] = "N" && [Anulado] = 0),[Some Value])

Sample source data would really assist greatly. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Whats the meaning of [Some Value] in your sintax???

For what i saw the rest of the sintax is the thing i need to achive

[Greg_Deckler]

Some column that you want to count. Could probably be any column.

[Anonymous]

It says that when i inset the new measure in the table..

I will tell you the data type from all of that

EnvioID = Bigint

Entregado = Nvarchar(1)

Rendido = Nvarchar(1)

Anulado = bit

[v-chuncz-msft · Accepted solution]

@Anonymous,

Check this article and change 0 to FALSE().