Power BI Matrix Viz Dispay help

[bezawak]

Hello Every One .

Good Morning I have an issue on how the below format can be acheived in Power BI Matrix viz or another type of viz that could help me resolve the issue ,Below is the layout and any help is much appreciated 

Indicator is the difference of between the Schedulde & Actual Dates

Country on rows

Approval Type 1 & 2 in the columns

schedule date & actual date on the values section

Indicator calcualted column -which is diff of dates which will be in values section

Country Name	Overall Status	Approval Type 1	Approval Type 2
	Completed|Status	ScheduleDate|Actual Date|Indicator	ScheduleDate|Actual Date|Indicator
Name 2	1 or  0 if schedule date is null| status is max value of difference of the indicator column	date1|date2|diff of dates	date1|date2|diff of dates

[v-gizhi-msft]

Hi，

I am confused about your requirement, and I try to create a sample pbix file:

pbix 

Hope this helps.

Best Regards,

Giotto ZHi

[bezawak]

Hello Thanks for you file

below is the format

if  schedule date is not null and if we have a value for difference then the over all status should be the max of the difference values  (Example :max of two like value should be 63,70 ) and overall status should be one column beside country

[v-gizhi-msft]

Hi,

Please try to create this calculated column:

Overall Status = IF('Table'[ScheduleDate]<>BLANK(),CALCULATE(MAX('Table'[Datediff by day]),ALLEXCEPT('Table','Table'[Country Name])))

And it shows:

Here is my new test pbix file:(I have made a bit changes to original data)

pbix 

Best Regards,

Giotto Zhi

[bezawak]

Hello 

 For me approvals are coming dimension approval 

country name from country dimension

actual schedule dates from fact 

i have written like this if(scheduledate<>blank()),calculate(max(diffofdates),allexcept(country,countryname)) it throws me an error

and also overallstatus should not get repeated in the layout  

Thanks

Kalyana