Forum Discussion
HELP! Calculating % Difference between two Table Visuals
Hello, I am trying to calculate the % difference between two table visuals. The table to the left of the red line is filtered differently than the table to the right of the line. These are...
Hi Anonymous -create measures to calculate the "Avg. Base Salary" and the "Market 50th" values.
AvgBaseSalary = AVERAGE('Survey Data'[Base Salary])
Market50th = MEDIAN('Survey Data'[Market 50th])
create a measure to calculate the % difference between
PercentDifference =
VAR AvgBase = [AvgBaseSalary]
VAR Market = [Market50th]
RETURN
DIVIDE(AvgBase - Market, AvgBase)
you can export to pdf >> Go to the File menu in Power BI Desktop."Export to PDF" option is there.
Hope this helps
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!