Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX - How to Count Rows of a table column which has some visualization filter

Dear Experts,   I have no access to Modelling tab, only access for BI report & I wonder how can i count each rows in below table which has been filtered (visualization filter).  >> I need to...
Need Help
Tutorial Requests
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    I make a test with data from two tables

    each row = COUNT(sheet1[nno])

distinctcount = DISTINCTCOUNT(sheet1[nno])

    Best Regards

    Maggie

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous

 

Try somehting like this

 

Measure =
COUNTROWS ( SUMMARIZE ( Table1, Table[Col1], Table[Col2] ,.....Other columns in the table visual) )
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Zubair,

     

    Thanks for your advice, but the column are from multiple tables, but each has a relation.

    How can we write the DAX formula, if it is from different tables?

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Hi Anonymous

       

      Start with the Many side Table.......

       

      Then Summarize will allow you to add column from the one side table

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Zubair_Muhammad

         

        Sorry, i'm a noob in DAX codding, can you help to elaborate on the DAX codding?

         

        or can I write it as:

        Measure = COUNTROWS ( SUMMARIZE ( Table1, Table1[Col1]), SUMMARIZE (Table2, Table2[Col1]) ?