Forum Discussion

siva_yellanuri's avatar
siva_yellanuri
New Member
2 years ago

Unable to get accurate result when comparing current data with previous data based on the filter con

Hello Team, when I compare the live table data with historical table data it is working  fine. If I use filter condition then figures are slightly changing and trends are not working . Request you  ...
Tips and Tricks
siva_yellanuri's avatar
siva_yellanuri
New Member
2 years ago

Hi Allison,

Thanks for your reply. Actually data is coming from the Business application so that is live data i wont get Report  view option to go to power query to update the changes instead of DAX. There is no relationships between snapshots, Opportunities tables. By using the Treatas function i make the relationship between these tables. I cann't send the Raw data. Request you please assist me why the figures in the tables are not accurate if i filter the data in the slicer.

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    2 years ago

     How are you getting on with solving this problem? 

     

    We need a bit more detail from you still around how your tables are related, TREATAS function is powerful, but as   mentioned, you need to be clear about which filters you're using and ensure they're related to the tables in your report or the measure that uses the TREATAS. 

    Can you share your treatas measures?

     

    Also, careful with your < and > as you're using these in a text field, so they may not behave how you expect.

     

    I have used Daxformatter.com to format one of your measures, makes it a bit easier to read:

     

    Opportunities_Unweigted Orderentry_Budget% =
    IF (
        RIGHT (
            SELECTEDVALUE ( Opportunities[Fiscal Period] ),
            4
        ) & "-"
            & LEFT (
                SELECTEDVALUE ( Opportunities[Fiscal Period] ),
                2
            ) < ( [Current_Quater] ),
        ( [c_ActualsWon_IND] / [c_Budget_IND] ),
        IF (
            [c_ActualsWon_IND] < [c_Budget_IND],
            DIVIDE (
                [c_TotalUOE],
                ( [c_Budget_IND] - [c_ActualsWon_IND] ),
                0
            ),
            DIVIDE (
                ( [c_TotalUOE] + [c_ActualsWon_IND] ),
                [c_Budget_IND],
                0
            )
        )
    )

     

     

    Anonymous

    siva_yellanuri