Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago

How to compute Brand by SOURCE ?

HI All   parry2k help me with the below post :-   https://community.powerbi.com/t5/Desktop/How-to-use-DAX-expression-to-count-number-of-brand-sales-gt-100K/td-p/2262931   Now i manage to comput...
Need Help
admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago

parry2k 

 

Yes , i just check , you give me the correct expression . now it working fine. 

 

Can i have one more request , that is add one more condition , only count those brand sales >100K only.  As i want to focus on high sales  brand.

Hope you can advise me.

 

Paul

 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

admin11 add this measure

 

Measure = 
SUMX ( 
    SUMMARIZE ( 
        SALES_T,
        SALES_T[SOURCE], 
        SALES_T[BRAND_C], 
        "@Sales", [SALES_T] //replace SALES_T with the measure you want to check for the value 
    ), 
    IF ( [@Sales] > 100000, 1 ) 
)
    
    // COUNTROWS ( VALUES ( SALES_T[BRAND_C] ) )

✨ Follow us on LinkedIn and subscribe to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡