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,
I have this measure which works perfectly.
M: LxD_invoiced_month = CALCULATE(SUM(Joint_data[related amount]),Joint_data[To consider]=true())
Tables PNL (1) and Joint_Data (many) are linked with a cardinality (1:many).
In order to get the result that I wanted, I had to create the column related amount in Joint_Data which is :
related amount = RELATED(PNL[Invoice_amount])
But I would like to take advantage of this cardinality and to not create a redundant column related amount and use directly Invoice_amount.
But the measures below don't work :
M: LxD_invoiced_month = CALCULATE(SUM(PNL[Invoice_amount]),Joint_data[To consider]=true())
M: LxD_invoiced_month = CALCULATE(SUM(RELATED(PNL[Invoice_amount])),Joint_data[To consider]=true())
Someone to help me ?
Thank you.
Solved! Go to Solution.
@sebastienke , Try like
M: LxD_invoiced_month = CALCULATE(SUM(PNL[Invoice_amount]),filter(Joint_data,Joint_data[To consider]))
or
M: LxD_invoiced_month = CALCULATE(SUMX(Joint_data,RELATED(PNL[Invoice_amount])),filter(Joint_data,Joint_data[To consider]))
@sebastienke , Try like
M: LxD_invoiced_month = CALCULATE(SUM(PNL[Invoice_amount]),filter(Joint_data,Joint_data[To consider]))
or
M: LxD_invoiced_month = CALCULATE(SUMX(Joint_data,RELATED(PNL[Invoice_amount])),filter(Joint_data,Joint_data[To consider]))
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 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |