Forum Discussion
Subtotal question
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!
2 Replies
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 BIDear 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]RETURNDIVIDE(__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
