Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Count ifS in Power BI

In Excel, I had created the below column and formula which checked several columns and if they were a match would count that instance.  I would like to set up a similar column in Power BI however it needs to be dynamic as the PowerBI will become a template and needs to be calculated on the fly with each new set of raw data. 

 

I have created a new column and have been playing with SWITCH and COUNTX but haven't cracked it yet. 

 

Any help greatly appreciated

 

 

Need Help

4 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi,

     

    Drag columns, B,D,W,AA to the visual and then write this measure

     

    =CALCULATE(COUNTROWS(Data),Data[Is the space occupied]="Empty")

     

    Hope this helps.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks so much for the quick reply. Sorry to say, I am not sure what you mean by "Drag columns, B,D,W,AA to the visual"

       

      However, I do need the calculated number in each row of the column as becomes part of a stacked chart. Sorry - sounds complicated!

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        7 years ago

        Hi,

         

        You have to first load data from your Excel file into PowerBI desktop and then select the Table visual.  Drag those columns to the visual and then write the measure i suggested.