lead percentage

[Anonymous]

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]

thank you

[Anonymous]

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.

[amitchandak · Accepted solution]

@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

[Anonymous]

hi there

i have yearMonth colunm in the below format

202109

how can i covert it to mmm-yy

[Anonymous]

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