Forum Discussion
Line value missing from combination chart
You have not selected total employee that is why it is filtered try with measure having all like
Total Employee new = calculate(Statistic[Total Employee],Filter(all(Statistic),[Statistic]="Employee")
or
Total Employee new = calculate(sum(Statistic[Value),Filter(all(Statistic),[Statistic]="Employee")
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
Thanks very much for taking the trouble to reproduce the issue - I do appreciate it. You have confirmed for me that this actually works. (and I actually have a different tab where this works).
The Y axis is set to 0 to Auto. I tried hard coding to 100 it changed the X-Axis! (but no measure appeared)
-If I move the measure to tooltips, the value appears correctly in the tooltip
-If I change the visualisation to table, the measure is shown
-If I click the measure and change "Show Values As" from "No calculation" to "Percent of Grand Total", the measure is shown (obviously not showing the value that I want)
Maybe it has something to do with DAX + filtering the value but as that appears to be the main difference in all of this.
My DAX is currently:
Total Employees = CALCULATE(SUM(Statistics[Value]),FILTER(ALL(Statistics[Statistic]),[Statistic]="Total Employees"))
hi Anonymous
If possible, could you please share your sample pbix file for us have a test, there should be something wrong in other.
You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Regards,
Lin