How would I go about computing the values of the "computed" column based on the following rules:
Thanks in advance.
Yes I have used DAX. The only difference is that my "table" is a Query. Again, it will display "YES" for rows that have "A" and "NO" for other rows with the same id which is not my goal.
I don't even know how your example works without specifying the ID anywhere?
Adding a screenshot where you can see my table, column names and values (some stuff is blurred because I can't show this information) and the DAX function and its result. Instead of "A" which was an example, it must match the value "Global". Blurred rows have other values than "Global" in the "Modèle" column.
Hi @mrupsidown ,
I am not sure if we have understood each other correctly.
My question was whether the DAX Statement as a
1. DAX Measure
2. DAX Calculated Column
The statement was written for 2. DAX Calculated Column.
If there are more columns, you can also try this one.
computed = IF(CALCULATE(MIN('Table'[field x]),ALLEXCEPT('Table','Table'[id])) = "A", "YES", "NO")
That doesn't work either. I was able to achieve what I wanted with the solution provided here: https://stackoverflow.com/a/68210381/1238965 but it uses an index column which is fine, except that there is apparently no way in PowerBi to hide a column in a table (yayy!).
No. Obviously this REMOVES the fields. I want to HIDE them, not REMOVE them. I need some fields for some calculations / bookmarks, but I don't want them to be DISPLAYED in my table.
Apparently, feature requests from YEARS ago, with HUNDREDS of votes still can't be implemented for whatever reason.
Have you solved this problem? If not, could you add more details?
I've tested the measure mentioned by mwegener, and it works! also, I don't think an index column is needed there.
besides, you don't need to worry that value can't be used for calculation if it's not in the table. It depends on the specific situation.
If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution 😁). so the others can find it more quickly.
Any question, please let me know. Looking forward to receiving your reply.
Community Support Team _Tang
I'm not sure if the fields really need to be present in the table visual to meet your requirements.
Can you describe/explain this more?
DAX calculations can be made based on fields that are not displayed in the visual. Also the visual can be filtered on fields that are not displayed in the visual.
Check out the News & Announcements to learn more.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.