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 ...
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
thank you