Forum Discussion

harirao's avatar
harirao
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Need to create a DAX by using Percentage

Hello All,

 

Required your assistance, i want to create measure for percentage calculation used Distinctcount, filter & sumx not getting correct result.
Measure1:

< No_Visibility_#Deals = CALCULATE(DISTINCTCOUNT(tbl_dep3_big_deal_perf_data_final_main[OpportunityId]),
FILTER(tbl_dep3_big_deal_perf_data_final_main, tbl_dep3_big_deal_perf_data_final_main[actual_visibility_Weeks]=0))
Measure2:
<No Visibility = SUMX(DISTINCT(tbl_dep3_big_deal_perf_data_final_main[Delivery Priority Code]),[< No_Visibility_#Deals])


In below screenshot, i have used %GT option for 3rd column which is giving correct result, (Total is 15where discount of OppId/ total 1/15(7%).
In last columns % is calculated on total which is 20 (1/20=5%), i want to create dax based on 2nd column that is discount  total

Thanks in advance for your help.

 

Regards,

Hari 

Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    harirao , Not very clear .

    You can create % of tota with a measure like

     

    divide([discount], calculate([discount], all(Table))

    divide([discount], calculate([discount], allselected(Table))

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    harirao , Not very clear .

    You can create % of tota with a measure like

     

    divide([discount], calculate([discount], all(Table))

    divide([discount], calculate([discount], allselected(Table))

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi , harirao 

    Could you please tell me whether your problem has been solved?
    If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

     

    Best Regards,
    Community Support Team _ Eason