Matrix not showing the Value on the column but Table is

[AvPowerBI]

Hi,

For some reason the Value on my Matrix Visualization is showing as BLANK but it meets the DAX condition for Availabilty % when I put this on a Table

Matrix

Table

The table shows the field IsActivity = Y

thats means then it should show the Availabilty % as 100% as the caculation for this is =1-(Unavailable Mins DIVIDED BY Paid Time Mins)

This is my DAX Calculation

Availability % =

VAR _Start = 1

VAR _First = CALCULATE(SUM(EngineerCalendar[Unavailable Mins]),CROSSFILTER(EngineerCalendar[CalendarKey], Visits[CalendarKey], Both))

VAR _Second = CALCULATE(SUM(EngineerCalendar[Paid Time Mins]),CROSSFILTER(EngineerCalendar[CalendarKey], Visits[CalendarKey], Both))

VAR _Final = _Start-(DIVIDE(_First,_Second))

VAR _IsActivity = IF( CALCULATE(SUM(EngineerCalendar[Avail Day Flag]),CROSSFILTER(EngineerCalendar[CalendarKey], Visits[CalendarKey], Both)) =1 || CALCULATE(SUM(EngineerCalendar[Worked Day Flag]),CROSSFILTER(EngineerCalendar[CalendarKey], Visits[CalendarKey], Both)) =1,"Y",

IF( CALCULATE(SUM(EngineerCalendar[Unavailable Mins]),CROSSFILTER(EngineerCalendar[CalendarKey], Visits[CalendarKey], Both))>0,"Y","N"))

VAR _Default = BLANK()

RETURN

IF(

_IsActivity="Y",

_Final,

_Default

)

[amitchandak]

@AvPowerBI , this is active is no more in row context that is why , it causing it

_IsActivity

Either use sumx as values or summarize any try

RETURN
sumx(Values(Table[engineer ID]),IF(_IsActivity="Y",_Final,_Default)

[AvPowerBI]

Hi @amitchandak 

Thanks for your reply, I have done your  suggeston, creting another DAX Measure but still showing as blan, any other suggestions?

Matrix

Table

Availability 2 % =
VAR _Start = 1
VAR _First = CALCULATE(SUM(EngineerCalendar[Unavailable Mins]),CROSSFILTER(EngineerCalendar[CalendarKey], Visits[CalendarKey], Both))
VAR _Second = CALCULATE(SUM(EngineerCalendar[Paid Time Mins]),CROSSFILTER(EngineerCalendar[CalendarKey], Visits[CalendarKey], Both))
VAR _Final = _Start-(DIVIDE(_First,_Second))
VAR _IsActivity = IF( CALCULATE(SUM(EngineerCalendar[Avail Day Flag]),CROSSFILTER(EngineerCalendar[CalendarKey], Visits[CalendarKey], Both)) =1 || CALCULATE(SUM(EngineerCalendar[Worked Day Flag]),CROSSFILTER(EngineerCalendar[CalendarKey], Visits[CalendarKey], Both)) =1,"Y",
IF( CALCULATE(SUM(EngineerCalendar[Unavailable Mins]),CROSSFILTER(EngineerCalendar[CalendarKey], Visits[CalendarKey], Both))>0,"Y","N"))
VAR _Default = BLANK()
RETURN sumx(Values(EngineerCalendar[Engineer ID]),IF(_IsActivity="Y",_Final,_Default)
)