Forum Discussion

Saxon10's avatar
Saxon10
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

SUM FREQUENCY from Data Table to Report Table (DAX Required)

  Hi,   I would like to get the unique count based on the data table (item and status) according to the comments in report table.   In Excel I am applying the following formula F2=SUM((FREQUENCY...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Saxon10 ,

     

    Check the formula.

    Column = CALCULATE(DISTINCTCOUNT('Table'[ITEM]),FILTER('Table','Table (2)'[comments]='Table'[STATUS]))

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Saxon10 ,

 

Check the formula.

Column = CALCULATE(DISTINCTCOUNT('Table'[ITEM]),FILTER('Table','Table (2)'[comments]='Table'[STATUS]))

 

Best Regards,

Jay

  • Saxon10's avatar
    Saxon10
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    thank you so much for your help. This is I am looking for it. Its very simple and awesome.