Forum Discussion

NETO13's avatar
NETO13
Regular Visitor
6 years ago

Count a dynamic measure

Hi,   I'm trying to calculate a dinstinct count of rows for a specific measure and couldn't find a way to do this. The scenario: I have a table with customers, quarters, quarter aging, revenue an...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
6 years ago

NETO13 

How a you selecting the customers you want to see in a visual?  If you want to count just the customer with a category of "IV" something like this would work.

IV Count = COUNTROWS( FILTER ( VALUES(Sales[Customer]),[Customer Group] = "IV"))

But I'm not sure that is what you are looking to achieve. 

  • NETO13's avatar
    NETO13
    Regular Visitor
    6 years ago

    jdbuchanan71 
    Didn't worked.

     

    the category is a created measure