Forum Discussion

LBarto90's avatar
LBarto90
Regular Visitor
3 years ago

Summarize a measure

Hey Folks,   I have a problem with a data table and cant figure out the problem. It would help me a lot if you have an idea on this issue.   There is a data table like this Name date value ...
Need Help
Show and Tell
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

LBarto90 If I am understanding correctly, perhaps something like this:

Measure = 
  VAR __Category = MAX('CategoriesTable'[Category])
  VAR __Table = SUMMARIZE('Table', [Name], "__Count", COUNTROWS('Table'))
  VAR __One2Three = COUNTROWS(FILTER(__Table, [__Count]<4))
  VAR __MoreThan4 = COUNTROWS(FILTER(__Table, [__Count]>3))
  VAR __Result = IF(__Category = "1-3", __One2Three, __MoreThan4)
RETURN
  __Result