Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

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

amitchandak
3 years ago
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