Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

how do i Count if

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.

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
    v-janeyg-msft
    5 years ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      v-janeyg-msft
      Community Support
      5 years ago

      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's avatar
    Fowmy
    Super User
    5 years ago

    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"
		)
)