Forum Discussion

madferit's avatar
madferit
Regular Visitor
7 years ago

Count values from different columns

Hi, im learning the basic and im stucked in a very simple dax. Maybe you can give me a hint on a table that im workingn on it. I need count how many time a value from a column match a value from a d...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

HI, madferit

You could use COUNTA Function to create a measure as below:

Q Item = CALCULATE(COUNTA(Table1[Date]) )

and use Drill mode in a matrix visualization as below:

Best Regards,

Lin

 

  • madferit's avatar
    madferit
    Regular Visitor
    7 years ago

    Hello, thanks for the answer. I tried this but the result it count me the total of rows with a single date, it give 9 for every single result.

     

    Regards