Subtotal question

[hnowotny17]

Hello,

I would like to kindly ask for a help.

I am suming up sold values from few different sources. In the end of the table I have an evolution to see, if the source is perfoming or not. Unfortunately I dont have last year data from all of the sources and thats why there is a blank space.

My question is regarding the subtotal - In the subtotal of the last 2 colums (LW vs LY and MtD vs LY) I would like to count only with sources, where are data from last year. That means that I would like to filtered out 3 sources marked by yellow colour. (Source no: 2, 9, 11).

Does anyone know, how to do it?

Many thanks!

[Shaurya]

Hi @hnowotny17,

Let's say you have a measure [LW vs LY] that calculates the total. You can use a filter context on it.

Ignore Blanks = CALCULATE([LW vs LY],FILTER('Table','Table'[LY]<>BLANK()))

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: How to Export Telemetry Data from Azure IoT Central into Power BI

[hnowotny17]

Dear @Shaurya,

thank you a lot for your reply.

I´ve tried to use this formula, but it didn´t allow me to add correct table.

The formula for this measure LW vs LY is following:

LW vs LY =

VAR __BASELINE_VALUE = [SO LY]

VAR __VALUE_TO_COMPARE = [SO LW]

RETURN

    DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)

Do you have any idea, how to "Ignore blanks" put here?

Many thanks and have a nice day!

Jan N