Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
03-09-2018 10:02 AM - last edited 06-26-2018 09:47 AM
Given a column with a list of values, computes the Shannon Entropy for that set of values. The single measure version of this is:
ShannonEntropy = SUMX( SUMMARIZE( Entities, Entities[Entity], "H(X)", -1*COUNTROWS(Entities)/COUNTROWS(ALL(Entities))*LOG(COUNTROWS(Entities)/COUNTROWS(ALL(Entities)),2)) ,[H(X)])
There is a single input, a column, in this case called Entities[Entity].
eyJrIjoiNTkzNTU5ZjMtNTRlNi00OWUyLWIzNjUtOWNiY2IxMTk0NWZlIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9