Solved: IF Formula

jbenson · ‎03-23-2021

How do I get column total and row today's balance to output what the bushels are for todays balance

Anonymous · ‎03-23-2021

Either you can have slicers on column and Row and display the Bushels in a card so that the card displays based on selection

or, if these are hardcoded value you are looking for then craete the below measure and display it in a card.

_Total_Today_bal = CALCULATE(SUM(table[bushels]), table[column] = "Total", table[row] = "Today's Balance")

Anonymous · ‎03-23-2021

Either you can have slicers on column and Row and display the Bushels in a card so that the card displays based on selection

or, if these are hardcoded value you are looking for then craete the below measure and display it in a card.

_Total_Today_bal = CALCULATE(SUM(table[bushels]), table[column] = "Total", table[row] = "Today's Balance")

IF Formula