Forum Discussion

DainTheTrain's avatar
DainTheTrain
Regular Visitor
4 years ago
Solved

How to Summarize Values Based on Count

I have a data source with a list of ID's and a Type: ID Type 111 A 222 A 333 A 444 B 555 B 666 C 777 D 888 E 999 F 000 G I created a table visual in...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  DainTheTrain ,

    Here are the steps you can follow：

    1. Create calculated column.

    Type_Column =
var _count=COUNTX(FILTER(ALL('Table'),'Table'[Type]=EARLIER('Table'[Type])),[ID])
var _countall=COUNTROWS('Table')
var _value=
DIVIDE(
    _count,_countall)
return
IF(
    _value<0.2,"Other",[Type])

    2. Place [Type_Column] and [ID]. and set [ID] – Count.

    3. Result:

    If you need pbix, please click here.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  DainTheTrain ,

Here are the steps you can follow：

1. Create calculated column.

Type_Column =
var _count=COUNTX(FILTER(ALL('Table'),'Table'[Type]=EARLIER('Table'[Type])),[ID])
var _countall=COUNTROWS('Table')
var _value=
DIVIDE(
    _count,_countall)
return
IF(
    _value<0.2,"Other",[Type])

2. Place [Type_Column] and [ID]. and set [ID] – Count.

3. Result:

If you need pbix, please click here.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly