Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

IF-CALCULATE

Hello All,  I want to filter with rating as per below  Total Sales < 8000  = 1  Total Sales 8000  to 10000 = 2  Total Sales  > 10000 = 3    I have created new column with follwing filter and it...
Need Help
BIReel's avatar
BIReel
Frequent Visitor
6 years ago

 

 

 

Measure =
VAR FilteredPrice =
    CALCULATE ( SUM ( Trans[Price.PRICE] ), ALLEXCEPT ( Trans, Trans[CUSTNUM1] ) )
RETURN
    SWITCH (
        TRUE (),
        FilteredPrice < 8000, "1",
        FilteredPrice > 8000
            && FilteredPrice < 10000, "2",
        // default case
        "3"
    )

 

 

 


Christopher Pollock @ LinkedIn

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

⚡Vist us at https://www.bireel.com/ for courses, development and consulting purposes⚡