Forum Discussion
MSMKM
Helper I
Helper Ihow to achieve % GT values
Hi Team,
i have table see below and i want to know that how will acheive % GT values
| Product | Sales | % of GT |
| A | 10 | 33% |
| B | 8 | 27% |
| C | 12 | 40% |
| Total | 30 |
|
MSMKM , Assume sales is measure or use sum(Table[sales])
Divide([M_sales], calculate([M_sales], allselected()) )
or
Divide([M_sales], calculate([M_sales], removefilters(Table[Product])) )
1 Reply
- amitchandak
Super User
MSMKM , Assume sales is measure or use sum(Table[sales])
Divide([M_sales], calculate([M_sales], allselected()) )
or
Divide([M_sales], calculate([M_sales], removefilters(Table[Product])) )