MULTINOMIAL 05-02-2020 21:14 PM

[Greg_Deckler]

In my recent quest to create or catalog as many DAX equivalents for Excel functions, I coded this one with one arm tied behind my back:

MULTINOMIAL = 
    VAR __Table = 
        ADDCOLUMNS(
            'Table',
            "Factorial",FACT([Column1])
        )
RETURN
    DIVIDE(
        FACT(SUMX('Table',[Column1])),
        PRODUCTX(__Table,[Factorial]),
        0
    )

eyJrIjoiYjhhNzIxOGMtOTBkMS00ZWFlLWFjZDMtNjRlMjk4NTE2ZGRmIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9