Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dynamic Count of Rows

Hi PBI Community,   I'm wondering whether you could help me with a problem I came across recently. I do have a lengthy DAX measure to correctly calculate a metric at different hierarchy levels and ...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous try this measure, change table and column name as per your data model.

     

    Count of Products = 
VAR __currentProduct = SELECTEDVALUE( Table3[Product] ) 
RETURN 
CALCULATE( 
    COUNTROWS( Table3 ),  
    ALLSELECTED( Table3 ), 
    Table3[Product] = __currentProduct 
)
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous try this measure, change table and column name as per your data model.

 

Count of Products = 
VAR __currentProduct = SELECTEDVALUE( Table3[Product] ) 
RETURN 
CALCULATE( 
    COUNTROWS( Table3 ),  
    ALLSELECTED( Table3 ), 
    Table3[Product] = __currentProduct 
)
mc2863's avatar
mc2863
Regular Visitor
5 years ago

attempting to use this solution, but the measure returns empty calculations. Is this measure possible with a table as a new measure column?  If I hard code the  value selection, the countrow works, but using selected value is just blank.