Forum Discussion
Creating a Dynamic Value within a Text Box that has filters
So I have a table that has a filter on it for which quarter we are looking at. In this case Q3. I have a measure that calculates the percent difference between two columns called Let Total Percent Difference. I was trying to create a dynamic value in my text box that shows the Let Total Percent Difference for Q3. The variable that holds the quarters is called MFB Quarter.
Table name = project data
MFB Quarter = Q3
value to show = total percent difference
When I do the calculations manually they should be 10.96% but this is what is gives me.
I can't for the life of me figure out how to do this. It has this part where it talks about filters and slicers affecting the value but it doesn't have a way to add any.
I have tried to look an answer up but no luck.
PLEASE HELP!
1 Reply
ACraig08 , I am assuming you have measure QOQ change % and you are using that
example
QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))
Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))QOQ % = divide([QTD Sales]-[Last QTD Sales],[Last QTD Sales])
Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0
