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.

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.