The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I've tried a few different things and I'm stuck. I think it might have to do with how my tables are related, but not sure.
I have this measure:
Here are my other measures:
Hi @Auto_queen
please try
TEST GP =
SUMX (
VALUES ( 'Table'[Name] ),
IF (
[Total Credit] <> [Total Adjust Fee Amount],
[Collected GP],
CALCULATE ( SUM ( 'Gross Profit'[TR1__GP_Amount__c] ) )
)
)
Sorry I should have said I tried that already and it did not work. It gave me a larger number 705917.60
Yes.
Collections table > Invoice Table (Many to One)
Collections is where I get the Total Credit measure.
Invoice Table > Closing Report Table (Many to One)
Closing report table is where I get the Total Adjust Fee Amount measure.
Gross Profit Table > Closing Report Table (Many to One)
Gross Profit table is where I get the closing report split measure and the total gp measure.
They are all active relationships.
@Auto_queen
There is no issue with the model. The 'Closing Report' table is dimention table that is filtering other tables. I think the problem is somehow comming from the HASONEFILTER conditions in the sub-measures.
Actually, looking at my table again, I think the error is with my "Total Adjust Fee Amount" measure.
When I have the "Name" column in the table that measure matches my total credit measure. When I take the "Name" column out the total adjust fee amount changes to 1,683,651. So, TEST GP formula is working because the total credit <> total adjust fee amount.
I just tried this formula change but it didn't work. Any suggestions? I appreciate your help through this.
Okay let me play around with those. I know there was a reason why I added that in there, but maybe the SUMX(VALUES) is all I need...
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
33 | |
20 | |
16 | |
15 |
User | Count |
---|---|
55 | |
50 | |
36 | |
35 | |
28 |