child objects

2 Topics

Calculate column with TRUE or FALSE values, according to values held in parent AND child table
Table 1 has ID and a date, and in this table I want to add a calculated column. Table 2 is a child of table 1 (FK is table1.ID), has its own ID and has a text column. The calculated column is to be TRUE or FALSE according to the value of table1.date (>= 01/10/2021 & <= 30/11/2021) AND whether table2.text has values of "VALUE A" OR "VALUE B". I've tried IF with LOOKUPVALUE etc... and get the (expected) "A table of multiple values was supplied where a single value was expected" error. I cannot fathom which DAX function to use for this...
Solved
RichHead1821
4 years ago Place DAX Commands and Tips
1KViews
0likes
2Comments
Hide/show/create panels based on amount of child objects in the data
How to dynamically add navigation panels into a PowerBI report based on the amount of child objects to report on? Do I need to write Javascript or C# or Python or how to implement this? For example when a user selects: parent object + 1 child object = 1 panel + 1 panel with child object data. => 2 pages in total (on screen and in pptx/pdf) parent object + 3 child object = 1 panel + 3 panels with child object data. => 4 pages in total (on screen and in pptx/pdf)
HulstB
6 years ago Place Report Server
574Views
0likes
0Comments