Forum Discussion

masch112's avatar
masch112
Regular Visitor
9 years ago
Solved

Counting rows in a visual (table) with one measure and two dimensions

Dear community,   I am using If-functions to check my data for unusual values (like negative revenue). I would like to count rows in a table that displays such an if-function. The if-function l...
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    masch112,

     

    In order to count the rows in this table, I somehow have to aggregate/group/summarize the measure by company and account name.

    You could use ALLEXCEPT function to count the row group by Company. This function removes all context filters in the table except filters that have been applied to the specified columns. Smaple DAX for you reference.
    Count = CALCULATE(COUNT(Table3[Value]),FILTER(ALLEXCEPT(Table3,Table3[Group]),Table3[Value]<0))

     

    If this is not what you want, please elaborate your requirement, so that we can make further analysis.

     

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

masch112,

 

In order to count the rows in this table, I somehow have to aggregate/group/summarize the measure by company and account name.

You could use ALLEXCEPT function to count the row group by Company. This function removes all context filters in the table except filters that have been applied to the specified columns. Smaple DAX for you reference.
Count = CALCULATE(COUNT(Table3[Value]),FILTER(ALLEXCEPT(Table3,Table3[Group]),Table3[Value]<0))

 

If this is not what you want, please elaborate your requirement, so that we can make further analysis.

 

Regards,

Charlie Liao