Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good morning,
I would like the following table calculated:
OFFICES ON MAP = CALCULATETABLE (VALUES ('OFFICE LIST' [OFFICE_DEST]), 'OFFICE LIST' [OFFICE_ORIG] = "OFFICE NAME")
would work dynamically, i.e. instead of the string "OFFICE NAME" there was the value selected by a drop-down filter
The "static" version works correctly, but when I try to use the OFFICE FILTER measure instead of "OFFICE NAME", defined as follows:
OFFICE FILTER = SELECTEDVALUE ('OFFICE LIST' [OFFICE_ORIG])
gives me the following error:
[i] [u] A 'PLACEHOLDER' function was used in a True / False expression used as a table filter expression. This is not allowed. [/ U] [/ i]
Thanks in advance for your attention, greetings
Alessio Romeo
Hi @Aromeo,
Current power bi does not support creating dynamic calculated columns/tables based on filter effects. They were working on different levels and you can't use the child to effet its parent level.
Notice: the data level of power bi(from parent to child level)
Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)
Regards,
Xiaoxin Sheng
Hi @Aromeo !
Try using the filter function:
CALCULATETABLE (VALUES ('OFFICE LIST' [OFFICE_DEST]), FILTER('OFFICE LIST' [OFFICE_ORIG] = [Measure]))
ps: A calculated Table is calculated when the datamodel is refreshed. It won't update when you only use the slicer.
Hope it helps!
Kind regards,
OD
Hi @OzkanDhont,
tried and no errors occur, but the Filter is not working (I get all the OFFICE_ORIG in the calculate table), even if I refresh. Other Suggestions?
Thanks, regards
Alessio Romeo
@Aromeo
It is not possible to pass dynamic values into Tables when you create them at model level. Model and the Reporting canvas (Visualization) are two different layers. When you build the tables, then they get loaded on the model and any slicer or filter selection from the canvas would not influence the model.
Based on your requirment, you make think of creating a virtual table within the measure.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |