Mismatch Visuals (DAX measure)

[rbalza]

Hi Powerbi Friends,

I am using linear gauge visual by MAQ software and I am having difficulty matching the data between the budget and scale. As you can see, budget is 150k where on the scale, it is showing 70k only. The problem comes when applying multiple visual filters. Was it something on my dax measure? Thanks in advance.

Actual =
CALCULATE (
    SUM ( 'Invoices'[Line Amount Calculation] ),
    FILTER (
        'Accounts',
        Accounts[Account Type] = "Revenue"
            || Accounts[Account Type] = "Sales"
    )
) + [Sales (Journals)] - [Credit Notes (Sales) - Total]

[Pragati11 · Accepted solution]

Hi @rbalza ,

Your 1st screenshot of the visual, I think it is just a scale formatting. i am assuming you haven't given any Minimum/Maximum values on this visual.

Try moving something in there then your scale will change

Thanks,

Pragati

[rbalza]

Hi @Pragati11 , thanks for taking the time on this. Not sure if this a bug but when I look at it this morning, it is working well. Whilst didn't do anything about it. 

[selimovd]

Hey @rbalza ,

where is the mismatch? What do you expect as a result?

Do you get the result you expect when you just use a table visual?

To be honest, I don't really understand how the expected result should look like.

Best regards

Denis