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.
Hi Im trying to Achieve below in Jan version of PowerBi,
i have a dimension table tblDimdate which has fldYear
and another transaction table tblTransactions which i want a caluculation of fldTranAmount based on multiselections of fldYear.
im able to achieve it for single selection but for multiselection how to pass the selected values to table which doesnt have any relation to this transaction table.
ex: CALCULATE(SUM(fldTranAmount ),ALLSELECTED(tblDimdate[fldYear])
can some one help me to rewrite this.
Solved! Go to Solution.
@Anonymous,
You may refer to the post below.
@Anonymous,
You may refer to the post below.
Thanks frend,
strange IN operators beahaves different, not working with curly braces{} when i put () it is working like charm.
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 |
---|---|
113 | |
103 | |
77 | |
66 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |