Calculate measure to get data for selected filter remaining should show 0

[Anonymous]

I want to create a measure which will have data similar to Column "Plan1" and "Plan2" based on the filter selections.

The point to note here is-

Filters: "Plan1" and "Plan 2"

Grid: "Plan" is pulled from the same table and are the same column.

data that needs to be calculated is bordered with red.

[v-juanli-msft]

Hi @Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

To reproduce your problem, 

1. I create a main data table (Sheet7) and calendar date table (date table) as below

2. create measure and calculated column to get a table as yours

3. create two new table

date1 = SUMMARIZE('date table','date table'[month'year])

date2 = SUMMARIZE('date table','date table'[month'year])

Note: don't create any relationship for the two tables

Then add "month'year" from these two tables in the slicers

3.create measures in Sheet7

plan1 = SELECTEDVALUE(date1[month'year])

plan2 = SELECTEDVALUE(date2[month'year])

plan1 sales = IF(MAX(Sheet7[plan calculated column])=[plan1],[Measure_sales],0)

plan2 sales = IF(MAX(Sheet7[plan calculated column])=[plan2],[Measure_sales],0)

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.