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!

     

lbendlin's avatar
lbendlin
Super User
5 years ago

Please define "parent Customer"  - is that the brand?

 

Are you saying 10/10 and 30/30 because the customers are different between brands L and N ?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi lbendlin 

 

I'm saying 10/10 and 30/30 because the customer name is different.