Forum Discussion
hnowotny17
Helper I
Helper ISubtotal 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. Unf...
Shaurya
Memorable Member
Memorable MemberHi 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
hnowotny17Dear 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