Forum Discussion
Creating table from a selected slicer value
Hi Gutts_Zero,
What type of table you mean? If you mean the calculated table, current power bi does not support to create dynamic calculated column/table based on filter effect, they do not work on the same data level, and you can't use child level to effect its parent level.
If you mean table visual, you should create a unconnected table or what if parameter table as source of slicer.
Then you can write a measure formula as filter to use on table visual to apply custom filter effect based on your selection.
Applying a measure filter in Power BI - SQLBI
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
I already have a what if parameter table as the source of slicer and I already have a table to contain the periods.
PMT calculate fine, it seems the issue is when I use the max() function to calculate the either the ppmt or ipmt of the respective row/period.
As seen in the screen shot below, pmt calculates and displays on the table visual as well as the dax formula for ipmt.
But when i put the ipmt into the visual table i get the error.