Creating a measure filtering dataset in Table

Question

I am trying to create a measure whereby I only select the values based on a certain category.

For example, I want to create a measure just totalling the PY Actuals so that I can use that measure in another measure say to find the difference between PY Actuals vs CY Actuals.

I'm a bit stuck on what measure to create here so any help would be appreciated.

antoniom · Accepted Answer

You can use CALCULATE&nbsp;[PY Actuals] = CALCULATE ( SUM ( Table[Total] ), Table[Category] = "PY Actuals" )&nbsp;

Forum Discussion

Creating a measure filtering dataset in Table

2 Replies

Related content

Need help creating a measure

Help to create DAX Measure

Error in create measure for filter

Creating a measure that is the value of another measure but ignores a filter

Dynamic measure filtering