Forum Discussion

danextian's avatar
danextian
Icon for Super User rankSuper User
9 years ago

How to create a filtered calculated table with more than one column.

Hello,   I'd like to create a calculated table taken from the data below. What I want  is to get the Case and Count column filtered based on the max value by case in count column. I do know how t...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
9 years ago

Hi Anonymous

 

Thanks  for the reply.

 

What I was trying to say was I would like to return just  two columns from the original table to a calculated one - Case and Count columns.  The  criteria is max value in Count  column  based on distinct values in Case column.

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
9 years ago

Hey,

 

Assuming you want to solve this with DAX:

 

If you are on Power BI or SSAS 2016 you can go with GROUPBY otherwise you can try SUMMARIZE (be aware that SUMMARIZE has its issues)

 

The GROUPBY can look like this

GROUPBY('BaseTable',BaseTable[Case],"Count", MAXX(CURRENTGROUP(),'BaseTable'[Count]))

Hope this helps