Forum Discussion

bidataservices's avatar
bidataservices
Frequent Visitor
2 years ago

Summary value from a table visual

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
Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    bidataservices , You should have measure like

     

    SUMX(
        Fact,     [Revenue to Defer]
    )
     
    SUMX(
        Fact,
        [Revenue]* [Defer %]
    )

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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