Forum Discussion
lead percentage
Learn Power BI - Creating Comprehensive Report by PBI Expert Mr. Vijay Perepa i have table
| Month of Date | Device Filter | Enquiries 0 |
| Dec-22 | Tablet | 0 |
| Nov-22 | Tablet | 1 |
| Oct-22 | Tablet | 1 |
| Sep-22 | Tablet | 0 |
| Aug-22 | Tablet | 0 |
| Jul-22 | Tablet | 0 |
| Jun-22 | Tablet | 0 |
| May-22 | Tablet | 0 |
| Apr-22 | Tablet | 1 |
| Mar-22 | Tablet | 2 |
| Feb-22 | Tablet | 3 |
| Jan-22 | Tablet | 0 |
| Dec-21 | Tablet | 0 |
| Dec-22 | Mobile | 6 |
| Nov-22 | Mobile | 10 |
| Oct-22 | Mobile | 91 |
| Sep-22 | Mobile | 56 |
| Aug-22 | Mobile | 18 |
| Jul-22 | Mobile | 164 |
| Jun-22 | Mobile | 58 |
| May-22 | Mobile | 22 |
| Apr-22 | Mobile | 47 |
| Mar-22 | Mobile | 41 |
| Feb-22 | Mobile | 10 |
| Jan-22 | Mobile | 5 |
| Dec-21 | Mobile | 1 |
| Dec-22 | Desktop | 6 |
| Nov-22 | Desktop | 8 |
| Oct-22 | Desktop | 15 |
| Sep-22 | Desktop | 12 |
| Aug-22 | Desktop | 19 |
| Jul-22 | Desktop | 48 |
| Jun-22 | Desktop | 64 |
| May-22 | Desktop | 150 |
| Apr-22 | Desktop | 26 |
| Mar-22 | Desktop | 88 |
| Feb-22 | Desktop | 31 |
| Jan-22 | Desktop | 14 |
| Dec-21 | Desktop | 3 |
how can calculate leas percentage for each month using dax
kindly help me with this
Anonymous , Try like
Divide(Sum(Table[Enquiries 0]), calculate(Sum(Table[Enquiries 0]), filter(allselected(Table), Table[Month Year] = earlier([Month Year]) )))
Divide(Sum(Table[Enquiries 0]), calculate(Sum(Table[Enquiries 0]), removefilters(Table[Data Device filter]) ))
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s
5 Replies
- amitchandak
Super User
Anonymous , Try like
Divide(Sum(Table[Enquiries 0]), calculate(Sum(Table[Enquiries 0]), filter(allselected(Table), Table[Month Year] = earlier([Month Year]) )))
Divide(Sum(Table[Enquiries 0]), calculate(Sum(Table[Enquiries 0]), removefilters(Table[Data Device filter]) ))
Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s
Hi Anonymous ,
Please try below steps:
1. create a measure with below dax formulaMeasure = VAR _total = SUMX ( ALL ( 'Table' ), [Enquiries 0] ) VAR _val = SUMX ( 'Table', [Enquiries 0] ) RETURN DIVIDE ( _val, _total )2. add a table visual with field and measure
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.