Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Create Quartiles by Groups and Removing Specific Values

Hello, this questions has been answered, but this is a variation that I need a little more help on. I have a dataset that looks like this: Time Class1 Class2 Subclass1 Subclass2 Vendor SKU...
Need Help
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

You could try REMOVEFILTERS:

 

Quartile1 =
SUMMARIZE (
    dataset,
    dataset[Class1],
    dataset[Class2],
    dataset[Subclass1],
    dataset[Subclass2],
    dataset[Vendor],
    "Q1",
        CALCULATE (
            PERCENTILE.INC ( dataset[rate], 0.25 ),
            REMOVEFILTERS ( dataset[Vendor] )
        )
)