Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need Help with DAX

Hi Power BI Community,   I need help in writing DAX for the below scenario, please find image attached.     I have 3 Columns, Customer, brand and Value.   If I select any slicer from Cus...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Anonymous ,

     

    Create a measure as below:

     

    Measure = 
var _num=SUM('Table'[Value])
var _deno=CALCULATE(SUM('Table'[Value]),FILTER(ALLSELECTED('Table'),'Table'[Customer ]=MAX('Table'[Customer ])))
Return
DIVIDE(_num,_deno)

     

    And you will see：

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

     

parry2k's avatar
parry2k
Super User
5 years ago

Anonymous Try these measure:

 

Sum Value = SUM ( 'Table'[Value] ) 

% = DIVIDE ( [Sum Value], CALCULATE ( [Sum Value], ALLSELECTED ( 'Table'[Brand] ) ) )

 

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  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.⚡