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 ta...
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.

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