Need to create a DAX by using Percentage

[harirao]

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 

[v-easonf-msft]

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

[amitchandak · Accepted solution]

@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))