Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hollow, everyone
In the following query, tables Policy and DateDimension has no relationship. I use UserRelationship to create a relationship between these two tables as filter argument for CalculateTable. Then using Summarize as expression to Broker_ID and Policy_Year.
But the query did not work.
Any ideas?
Thank you
Dennis
CALCULATETABLE (
SUMMARIZE( Policy, Broker[BROKER_ID], DateDimension'[Policy_Year] ),
USERELATIONSHIP( Policy[EFFECTIVE_DATE], 'DateDimension'[DateKey] )
)
Solved! Go to Solution.
@12Bowers12 , Add measure and there you use userelation.
calculate(countrows(Policy), USERELATIONSHIP( Policy[EFFECTIVE_DATE], 'DateDimension'[DateKey] ))
Add this a column in your summarize and try.
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
Thank you, Amitchandak, I will test it. Have a goo day.
@12Bowers12 , Add measure and there you use userelation.
calculate(countrows(Policy), USERELATIONSHIP( Policy[EFFECTIVE_DATE], 'DateDimension'[DateKey] ))
Add this a column in your summarize and try.
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |