Forum Discussion
Matrix visual
Hi All, My scenario is to visualize the availability % of the Products in each level of hierarchy in a matrix visual. In which I have to show % value as 0 even if any one of the job failed to run o...
Hi, Anonymous ;
You could try ISINSCOPE() , Here I create a simple file and i create a measure.
Measure = IF(ISINSCOPE('Table'[Date]),IF(SUM('Table'[job faild])>0,0,AVERAGE('Table'[job faild])),AVERAGE('Table'[job faild]))The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.This is perfect! Got the required output. Thankyou so much v-yalanwu-msft.
Appreciate your support.
This is perfect! Got the required output. Thankyou so much v-yalanwu-msft.
Appreciate your support.