% Calculation in DAX with detail data

[Anonymous]

We have a data as below, so I would like to calculate the % based on status (R) availability with in a week

For ex for the meter number 214243107 then R available 4 times in a week, so the cal will be 4/7*100, same way need to display % for othres

Format needs to be displayed exactly below , will this possible by wringing some DAX measure ??

[hanuraolm]

Thanks, Kim for sharing the file and it's really helpful to understand the code & intermediate tables to solve the issue

[hanuraolm]

thanks, Kim for the details

here we are extracting different weeks' data, if we select the next week then it should display all dates for that week.

tried to generate an intermediate table based on the main data as you pointed.

Table =

var _Temptable = SUMMARIZECOLUMNS(Data[Date])

return

UNION(

SELECTCOLUMNS(_Temptable,"Date",Data[Date],"Column",FORMAT(Data[Date],"dd-mmm")),

ROW("Date",BLANK(),"Colun","%")

)

1. unable to generate a sequence

2. without seq used these columns in measures then it's given weird numbers.

measure changed as per the above table result as below 

[Jihwan_Kim]

Result measure : =
VAR _connectingtable =
TREATAS ( VALUES ( Columns_2[Date] ), Data[Date] )
VAR _rcount =
CALCULATE ( COUNTROWS ( Data ), Data[Value] = "r" )
VAR _allcount =
COUNTROWS ( Data )
RETURN
SWITCH (
SELECTEDVALUE ( Columns_2[Column] ),
"%", DIVIDE ( _rcount, _allcount ) * 100,
CALCULATE ( SELECTEDVALUE ( Data[Value] ), _connectingtable )
)

Link to the pbix file