cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kavitabehera
Advocate II
Advocate II

How to create calculated table with numeric condition.

I want to create a calculated table with Region and Sales where the sale is greater than 500,000. 

This is the DAX I created to generate the table.

kavitabehera_0-1667481101516.png

I can also create a text based filter condition, but I am unable to create the numerical condition.

kavitabehera_1-1667481215547.png

 

DAX

SUMMARIZECOLUMNS (
    Orders[Region],
    FILTER(Orders, Orders[Region] = "South"),
     "Sale", SUM ( Orders[Sales] )
)

 

@Helper  @tamerj1 

 

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

I am not sure if I understood your question correctly, but please try below whether it suits your requirement.

 

New table =
FILTER (
    SUMMARIZECOLUMNS ( Orders[Region], "@Sale", SUM ( Orders[Sales] ) ),
    [@Sale] >= 500000
)

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

Hi,

I am not sure if I understood your question correctly, but please try below whether it suits your requirement.

 

New table =
FILTER (
    SUMMARIZECOLUMNS ( Orders[Region], "@Sale", SUM ( Orders[Sales] ) ),
    [@Sale] >= 500000
)

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Thank you @Jihwan_Kim for giving the solution it worked. 

 

Meanwhile I also found this alternative that works too.

SUMMARIZECOLUMNS (
    Orders[Region],
    FILTER ( VALUES ( Orders[Region] ), [Total Sale] > 500000 ),
    "Total Sale", Sum(Orders[Sales])
)

 

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors