topic Re: lead percentage in DAX Commands and Tips

lead percentage

Anonymous — Tue, 17 Jan 2023 18:13:51 GMT

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

Re: lead percentage

amitchandak — Wed, 18 Jan 2023 02:09:00 GMT

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

Re: lead percentage

Anonymous — Wed, 18 Jan 2023 06:11:31 GMT

Hi Anonymous ,

Please try below steps:
1. create a measure with below dax formula

Measure = 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.

Re: lead percentage

Anonymous — Sat, 21 Jan 2023 17:11:13 GMT

thank you

Re: lead percentage

Anonymous — Sun, 22 Jan 2023 13:25:37 GMT

Hi Amit could you help me with navigation

like if select name in the filter it should take me to other pager and open all the information

like if i select customer name like vijay in the filter and click on vijay it should take me other page

Re: lead percentage

Anonymous — Fri, 27 Jan 2023 10:06:08 GMT

hi there

i have yearMonth colunm in the below format

202109

how can i covert it to mmm-yy