How to Calculate Mode on Value coloumn of summarized table ?

[DeepDive]

Hi Experts,

I want to calculate mode of value column of summarized table : For example am using below dax to get the table summarized, summarized dax and summarized table is below.. now I want to calcualte mode  " Count of order by customer"

summarized_Table = summarize('Sales','Sales'[CustomerKY+Date]),"Count_Freq",CALCULATE(COUNT('Sales'[CustomerKY+Date]),
ALLEXCEPT('Sales','Sales'[CustomerKY+Date]),FILTER('Sales','Sales'[SalesValue]>0))

[v-yuta-msft · Accepted solution]

@DeepDive ,

Click query editor-> transform-> split columns by the left most space like below:

 

Then you can achieve the Customer and Date columns:

 

Finally modify the dax like below:

summarized_Table = 
SUMMARIZE (
    'Sales',
    'Sales'[Customer],
    "Count_Freq", CALCULATE (
        COUNT ( 'Sales'[Customer] ),
        ALLEXCEPT ( 'Sales', 'Sales'[Customer] ),
        FILTER ( 'Sales', 'Sales'[SalesValue] > 0 )
    )
)

 

Community Support Team _ Jimmy Tao

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

[jdbuchanan71]

@DeepDive 

Here is a good article on statistical-patterns.  Mode is towards the top of the aticle.

https://www.daxpatterns.com/statistical-patterns/