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.
Sooo.... I have exhausted options, video's and forumns for a solution. Mutliple attempts with SUMX and SUMX w/ SUMMARIZE. None leading to a correct total.
Customer and Item No-Description are from two different dimension tables. The solutions attempted would have worked if first two columns both existed in same table.
Cnt Fcst equals Bdgt is an if/then measure as follows:
So total is 4, which is correct at an Item No-Description level, But INCORRECT when adding column for Customer ID. Correct total should be 430. Each customer/item combination where Budget ='s Forecaset should be 1 and the total (customer/item) would total 430.
Hope this is sufficient to get some feedback on the correct pattern.
As Always, appreciate the help.
Spencer
Solved! Go to Solution.
So here is the fix... Two seperate tables requires the SUMMARIZE to be used w/ BOTH Filter context and SUMX.
Like the following:
So here is the fix... Two seperate tables requires the SUMMARIZE to be used w/ BOTH Filter context and SUMX.
Like the following:
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |