topic How create class inside a column in DAX Commands and Tips

How create class inside a column

GuillaumePower — Fri, 23 Feb 2024 16:28:37 GMT

Hello, i would like create class inside a column, to sum some product by this class, for example create a class all the 10 items from my column and give it a number or letter.

Thanks in advance

class with letter for each group of 3 numbers

1	A
2	A
3	A
4	B
5	B
6	B
7	C
8	C
9	C
10	D
11	D
12	D
13	E
14	E
15	E
16	F
17	F
18	F
19	G
20	G
21	G

Re: How create class inside a column

lbendlin — Sat, 24 Feb 2024 00:17:30 GMT

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

Re: How create class inside a column

GuillaumePower — Thu, 29 Feb 2024 09:22:01 GMT

In fact, I want to divide in some groups a table without using an expression like a switch (A :if >10;B if > 20 and so on).

Simply create 3 class in a table with the same number of elements in each class.

I think that the function SAMPLEAXISWITHLOCALMINMAX could help me, but I have not found the right way to use it. Is it more clear ?

Re: How create class inside a column

lbendlin — Sat, 02 Mar 2024 03:16:05 GMT

Interesting. That function is not listed in the official documentation

but when you spell it out it will appear

The inofficial documentation is equally vague SAMPLEAXISWITHLOCALMINMAX – DAX Guide

This article makes a reference that may help more Chris Webb's BI Blog: DAX Machine Learning Functionality Used By The Key Influencers Visual In Power BI (crossjoin.co.uk)