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.
Hello Power BI Folks,
I created a calculated table bases on the folowing DAX and this DAX still works 🙂
Workschedule = SUMMARIZE( GENERATE( M, CALCULATETABLE (VALUES( 'Calendar'[Date]),DATESBETWEEN('Calendar'[Date],'M'[scheduledStart],'M'[scheduledEnd]))),'Calendar'[Date],M[SystemUserId],M[ActivityId],M[FullName],M[ContractUrenPerWeek],M[Department],M[BusinessUnit],M[Subject],M[Description])
The result of this working DAX is a table with sometimes rows with ActivityId is empy, and sometimes ActivityId contains a value.
Now I need a (new?) calculated table with only row values with M[ActivityId]=BLANK(). Based on this new calculated table with a filter I'm able to create an essential relationship. (filter out in visual, page level or report level is not possible).
Any ideas? Help is greatly appreciated!
Solved! Go to Solution.
Hi @mvananaken,
You can simply use the "Workschedule" table to get a new table which you want.
Formula:
New Table =CALCULATETABLE( Workschedule, Filter(All(Workschedule),M[ActivityId]=BLANK())
Regards,
Xiaoxin Sheng
Hi @mvananaken,
You can simply use the "Workschedule" table to get a new table which you want.
Formula:
New Table =CALCULATETABLE( Workschedule, Filter(All(Workschedule),M[ActivityId]=BLANK())
Regards,
Xiaoxin Sheng
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 |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |