how do i Count if

[Anonymous]

Brand new to PowerBI. Lots of excel experience... I'm sure this question gets asked all the time.

Trying to create a new table calculated from a flat table. Flat table is named "SMT_Export".  New table is named "Sites_by_tech"

I have the first column pulling the Regions from flat table as follows:  =DISTINCT(SMT_Export[Region]).  generates a column with 4 values (north, south, east, west)

I need column 2 to be a count value for the following conditions:

SMT_Export[Region] = Sites_by_tech[Region]

SMT_Export[Site Status]= "ON-AIR"

SMT_Export[NR]= TRUE

Help please.

[Anonymous · Accepted solution]

fantastic! i had to correct formatting on the true/false column, but appears to be working.  If i want to add additional columns with similar calculations, do i add to the above ADDCOLUMNS:

"Count2",
		CALCULATE(
			COUNTROWS(SMT_Export),
			SMT_Export[LTE] = True,
			SMT_Export[Site Status] = "ON-AIR"
		)

 ETC?

[Anonymous · Accepted solution]

fantastic! i had to correct formatting on the true/false column, but appears to be working.  If i want to add additional columns with similar calculations, do i add to the above ADDCOLUMNS:

"Count2",
		CALCULATE(
			COUNTROWS(SMT_Export),
			SMT_Export[LTE] = True,
			SMT_Export[Site Status] = "ON-AIR"
		)

 ETC?

[v-janeyg-msft · Accepted solution]

Hi,  @Anonymous 

If you have already created a new table and want to add a new column, you can directly add calculated column.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@Anonymous 

Creat your table as follows:

Sites_by_tech = 
ADDCOLUMNS(
	VALUES(SMT_Export[Region]),
	"Count",
		CALCULATE(
			COUNTROWS(SMT_Export),
			SMT_Export[NR] = True,
			SMT_Export[Site Status] = "ON-AIR"
		)
)