Get the % based on filter on one field but ignore the filter/slicer on date

[deedeedudu]

Hi 

I have two tables coming from different sources but with similar column names and information as following

Table ABC

Table EFG

I have created a Calendar table and have created Columns to slice data as per custom data ranges:

Sample: 

This Month =

IF (

DATEDIFF (

'Calendar'[Date],

TODAY(),

MONTH

) = 0,

"This Month",

"No"

)

These columns are used as a slicer for a table that displays summarized data for all the customers

Scenario:

I need to calculate Delivery Rate = (Delivered/ Sent)*100%

If i don't apply any filter on Customer Name and don't use any of the slicers for data ranges then the Delivery Rate would be

= (SUM(ABC[Delivered]) + SUM(EFG[Delivered])) / (SUM(ABC[Sent]) + SUM(EFG[Sent]))

 = 68.20%

Problem:

I want to create a measure that calculates Delivery Rate for 

a. This Month

b. Last Month

ignoring the slicers for static date ranges but considering the filter for customers.

Eg. 

If I have selected a filter for Customer Name= BB and irrespective of whatever i choose in the static date range slicers my new measures should give the following:

This Month = 50%

Last Month = 45%

[amitchandak]

@deedeedudu , My suggest would field parameter with measure using date table and time intellignece

measures

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))

new column

Month Rank = RANKX(all('Date'),'Date'[Month Start date],,ASC,Dense)

Measure
This Month = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Month Rank]=max('Date'[Month Rank])))
Last Month = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Month Rank]=max('Date'[Month Rank])-1))

With a separate date table, it should work for the customer

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA