Forum Discussion
ondrej-cdc
2 years agoFrequent Visitor
PBI perform inner or outer join
Hello everyone, I would like to aks you about data modeling in Power BI. If I choose my tables set like star schema at model I dont understand how to set inner join or outer join. If I will be speci...
santiagomur
2 years agoResolver II
hi,
try this measure,
dynamic filter =
calculate(
countrows( transport[period_key])
)
ondrej-cdc
2 years agoFrequent Visitor
Hello, thank you for your advice, but I have the following error and I couldnt find correction. See a screenshot attached. Error says: A single value for column 'period_key' in table 'transport' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
Thank you in advance,
Ondrej