Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Get Count - Filtering from 2 columns

    Bronze Contributor
    Posted 8 days ago
      |   view attached
    Hi there,

    I'm looking for a simple DAX, which will give me the count from 2 different columns

    See attached excel for your reference.

    Please note: I do not have a date column. I have a column "Quarter", in which we have mentioned Q1, Q2, Q3 and Q4

    There are other 2 columns i.e. Status1 and Status2

    From Status1 - for Q1 - I need to filter "No" and get the count, Similarly filter Q2 and get the count of "No"

    Looking for below output within PBI


    Thanking you in advance

    ------------------------------
    Prem Guru
    ------------------------------

    Attachment(s)

    xlsx
    Quarter.xlsx   14 KB 1 version


  • 2.  RE: Get Count - Filtering from 2 columns

    Posted 8 days ago
      |   view attached
    Hi Prem,

    You can follow the attached file.

    Rd

    ------------------------------
    Rd 3nidad
    Senior Finance Analyst
    ------------------------------

    Attachment(s)

    pbix
    Filter.pbix   29 KB 1 version


  • 3.  RE: Get Count - Filtering from 2 columns

    Bronze Contributor
    Posted 8 days ago
    @Rd 3nidad,

    Thanks! I can see we are getting the current output.

    But, is there a way - we do not Unpivot the columns and simply create some DAX​

    I have more 8 columns of Status. When all the 10 columns are Unpivot some of my visuals are showing inappropriate values.

    Please advise. Thanks!

    ------------------------------
    Prem Guru
    ------------------------------



  • 4.  RE: Get Count - Filtering from 2 columns

    Posted 8 days ago

    Hi Prem,


    I don't really get what you mean, if you have 8 columns status, that should work the same as 2 columns unless there are other columns which are are really status. It is possible to do it without using unpivot but every status column is equivalent to 1 measure and you cannot have the same as result. You would have as per below table.

    I suggest that you show the snapshot of your table and let see what other option we may have.



    ------------------------------
    Rd 3nidad
    Senior Finance Analyst
    ------------------------------

    Attachment(s)

    pbix
    Filter.pbix   30 KB 1 version
    xlsx
    Quarter.xlsx   17 KB 1 version