Summary value from a table visual

[bidataservices]

Hi all,

I have a table in Power BI, example below, that uses a  number of measures taken from two tables. 

What I need is to show the total deferred revenue value highlighted in a tile visual. Struggling with this. I have tried the following measure but it does not give me the correct figure:

Deferred_Revenue_Total = SUMX(

    VALUES(Fact[FactID]),

    [Revenue to Defer]

)

Any help would be appreciated

[Anonymous]

Hi @bidataservices ,
We can't determine the relationship between your MEASURE creation process and your table.

Can you provide some sample data? We can better understand the problem and help you.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@bidataservices , You should have measure like

SUMX(

    Fact,     [Revenue to Defer]

)

SUMX(

    Fact,

    [Revenue]* [Defer %]

)

[bidataservices]

Thank you but that does not give me the right number