Forum Discussion
Anonymous
4 years agoNot applicable
Not showing duplicates in visual
Hello everyone, Maybe someone can help me with this problem. I created a PieChart based on my dataset. The visual displays results of testcases with repect to a softwareversion. So some testcases w...
- 4 years ago
Hi, Anonymous
Latest_Date = var MaxDate = CALCULATE(MAXX(Users,Users[Date]), ALLEXCEPT(Users,Users[USER-ID])) return MaxDateIs this something that would fulfil your request?
Anonymous
4 years agoNot applicable
Hey vojtechsima ,
I have a Follow-Up question. is this also possible for only the selected values. I think this method refers to all values that are in Users. Can I also just refer to the values in table visual? So that the measure only takes these values into account instead of all?
Thanks
vojtechsima
Super User
4 years agoHi, Anonymous,
You can filter only Selected Values using ALLSELECTED function,
please refer here:
https://docs.microsoft.com/en-us/dax/allselected-function-dax
- Anonymous4 years agoNot applicable
Thanks for the fast reply,
But if I do that it results in the same problem as state here.
https://community.powerbi.com/t5/Desktop/Measure-not-calculating-all-rows/m-p/2172462#M797802
And a lot of rows stay empty