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