Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
When do we use the TableX[ColumnX] in Values TableX[ColumnX]?
I have a matrix below and in the calculate measure I have to add the filter:
Calculate (.... , Table[ItemCd] in Values Table[ItemCd]) in order for the formula to work
Can the power bi gurus here explain why this is so?
Thanks!
EAEA
@Anonymous
Check if ALLSELECTED meets your requirement.
Hi @Anonymous ,
Can you upload sampledata, pbix and output expected to Google/One Drive and share the link here to find a solution.
Cheers
CheenuSing